Column Index Numbers

A

ajpowers

Where do I find a list of index number meanings? For example what doe
the "2" and "0" mean at the end of this formula? I need to know fo
all index numbers.

=vlookup(e5,sheet1!$b$7:$c$228,2,0)

Thank
 
A

Alan Beban

ajpowers said:
Where do I find a list of index number meanings? For example what does
the "2" and "0" mean at the end of this formula? I need to know for
all index numbers.

=vlookup(e5,sheet1!$b$7:$c$228,2,0)

Thanks
Click to expand...
You can find this information in the on-line help for VLOOKUP or by
looking at the VLOOKUP function wizard when entereing the formula.

The 2 refers to the second column of the lookup table; in the case
above, Column C. The 0 (or FALSE) is the argument to lookup an exact match.

Alan Beban
 
P

Peo Sjoblom

the 0 is just a representation of FALSE

=VLOOKUP(a1,range,2,FALSE)

1 can be used for TRUE

as far as the index numbering it is easy, 1 is the first column in your
lookup table so in your example
it is column B, now if your table is B1:H4 and you use 4 you will return the
value from column E

B = 1, C = 2, D = 3 and E = 4

you'll get an error if you try to get 4 from your example since it only has
2 columns

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
B

Bob Phillips

The 2 means the column within the lookup range, the 0 is not an index, but
a Boolean, for whether the lookup table needs to be ordered or not.

Best place to look - Help!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top