Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel xp training - Vlookup

excel xp training - Vlookup

ResolvedVersion Standard

Tue 28 Nov 2006, 12:37 Delegate Jennifer said...

Jennifer has attended:
Excel Intermediate course
Excel Advanced course

Vlookup

What reason is there that my vlookup finds some data but not others? Could this be something to do with cell formatting?

Thanks!

Tue 28 Nov 2006, 13:08 Trainer Amanda said...

RE: Vlookup

Hi Jennifer

Do you get any error messages coming up in your spreadsheet in the cells where the Vlookup is not working properly?

Perhaps if you could provide a bit more information about your problem we might be able to solve it.

thanks
Amanda

Tue 28 Nov 2006, 17:29 Delegate Louise said...

RE: Vlookup

I think that you may get the wrong results by not having the last (optional) part of the formula that allows the table to be in ANY order rather than strict numerical/alphabetical. Without it, it will find the first/closest match then stop.

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel xp training - Vlookup

Vlookup

RE: Vlookup

RE: Vlookup

Excel articles

Excel tip:

Outlining - ungrouping rows or columns