V-Lookup Formulas

[John L. Skager]

I need to understand the exact steps for putting in
the "table array" for these types of formulas (all other
pieces of the formuala are understood). I have read the
the help topic and understand what they are asking for-a
range name-however I don't quite understand the steps
involved. And once I have understood how to create the
range and range name, how do I put it into the formula
wizard. Do I have to type it in manually??

Thanks John

 

[Aladin Akyurek]

You don't want hand-holding of a wizard, do you?

VLOOKUP requires

(a) a lookup value;
(b) a lookup table (like A2:E40);
(c) the column index from which to fetch/retrieve the value associated with
the lookup value;
(d) match type (either 0 or 1, 0 for exact fit between the lookup value and
the value in the first column of the lookup table, 1 for aproximate/close
fit).

So:

=VLOOKUP(B1,LTable,2,0)

where LTable is say G2:J25.

This formula looks up the value in B1 in LTable, that is, it compares B1
with values in G2:G25. When it finds a G-cell that exactly fits or equal to
B1, fetches the value from I2:I25 whose position corresponds to the position
of the value that fits the lookup value.