V-Lookup?

[Cozmo35]

I can't wrap my brain around the process of a V-lookup. Can someone explain to me in a step by step, elementry style format (possibly with numbered steps) how I can do a V-lookup.

** WARNING: It has been tried before with no luck.

 

[VoG]

See if this helps http://www.contextures.com/xlFunctions02.html

 

[Zack Barresse]

Hi there,

VLOOKUP() has four syntax parts.
1) value to find
2) table range
3) column to return if match found
4) exact or not exact

VLOOKUP() will ALWAYS look in the left-most column of the table range to find a match. If a match is found, it will offset that column by the number of columns specified in the third part of the syntax. So if your range is A1:B10, and a match is found (in column A), and your third syntax is a 2, then the value in column B corresponding to the row it was matched from column A will return. For example, if a match was found in A5, then B5 value will be returned.

Another similar function is HLOOKUP(), where it will search the first row of data, similar to VLOOKUP(). If you want a more diverse set of functions, the INDEX/MATCH combo works here, as you can search whatever column/row you specify.

HTH

 

[crook_101]

Hi,

This should help.......

http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a-simple-tutorial-part-i/

Ian.