Using VLOOKUP Part 1

www.teekond.co.uk - Original Photo Prints

VLOOKUP is a really useful, but often mis-understood function. It can be used for looking values up from a list, either finding an exact match or the nearest match.

Category:

Howto & Style

Tags:

• excel
• spreadsheet
• vlookup
• function
• help

[kashuish]

y do we rite false??

[edkinsconsulting]

Hi. Writing false at the end forces the function to find an exact match or return an error. If you set it yo true, the function will find the closest match numerically. This is useful if you are looking up numerical values, but as in the example we wanted to look up names, we don't want the function making any assumptions and we want it to find the exact name, so we set it to false. Hope that helps. Cheers Simon

[ncbookz]

this is great i have college degree in math and i read the instructions 10 times but this video explained in one sitting

[ollie101111]

I have been trying to understand this function from a 'dummies' book for hours, without success. Cheers, I get it now !!

[atlejordalhaaheim]

Thanks a million. Been looking for this function for quite some time now

[tuan1765]

I got dizzy because of the camera moving with the cursor. But great video.

By the way, if you write "true" for the last argument, it will choose the next nearest lower number, but then your range must be sorted from lowest to highest.

[bigworld1001]

thank you for posting...I've just begun working with the vlookup function and found this short demo to be quite helpful.

[kashuish]

thank uuuuuu sooooooo much it was helpful

[kashuish]

where is part 2

[StevenX12]

really great thanks!

[yousef82us]

very helpful thank you