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 » Vlookups and exact matches

Vlookups and exact matches

ResolvedVersion 2007

Mon 7 Nov 2011, 15:58 Delegate Martha said...

Martha has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Vlookups and exact matches

how to find an exact match with vlookups

Wed 9 Nov 2011, 14:13 Trainer Paul said...

RE: vlookups

to find an exact match you must place "false" as the 4th part of your vlookup function.

Does that answer your question?

thanks
Paul

Wed 16 Nov 2011: Automatically marked as resolved.

Excel tip:

Excel 2010 Shortcuts - Start and End of the Worksheet

Did you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard?

Press Ctrl + Home key to move the cursor to cell A1

Press Ctrl + End key to move the cursor to the end of the current worksheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Vlookups and exact matches

Vlookups and exact matches

RE: vlookups

Excel articles

Excel tip:

Excel 2010 Shortcuts - Start and End of the Worksheet