Column Index Numbers

[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

 

[sachinattri]

There is no list I guess. "2" is the number of the Column from the lef
hand side of your table where you want the value to come from. If yo
want the value to come from the 10th column of your table then pu
"10". all of it depends on which Column you want to use.

"0" is False meaning it would get the Exact match for you. if you pu
"1" you would get the closest match.

clear?

Thank

 

[Alan Beban]

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

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

 

[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)

 

[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)

 

[ajpowers]

There is a list, I've seen it. Has anyone else

 

[Peo Sjoblom]

. if you put "1" you would get the closest match.


If the lookup table index 1 is sorted in ascending order

--

Regards,

Peo Sjoblom

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

 

[Alan Beban]

You're confused. The numbers in built-in formulas--what you seem to be
referring to as "index numbers"--mean different things in different
formulas.

E.g., you already have several answers relating to the 3d and 4th
arguments to the VLOOKUP formula. The numbers in the arguments of the
ADDRESS function, for example, mean entirely different things depending
on whether you're referring to the 1st, 2nd, 3rd or 4th argument.

Alan Beban