Table array in VLOOKUP (EXcel 2003)
 

Hi

I use the VLOOKUP formula: =VLOOKUP(C21;PALIER;2) in which PALIER is a table
array and it works. I want now to have the "PALIER" changed by getting it
from another cell: =VLOOKUP(C21;C22;2) = i wrote "PALIER" in cell C22....
and that does not work anymore.

Is it a format issue , a table array issue or a Vlookup issue ?

Thanks.
jerome

Table array in VLOOKUP (EXcel 2003)
 

"Ron Coderre" wrote:

The second argument of the VLOOKUP function is a range reference.
What you want it to do is interpret the text in C22 as a range.

Try this:

=VLOOKUP(C21;INDIRECT(C22);2)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"J BRAUD" wrote:

Hi

I use the VLOOKUP formula: =VLOOKUP(C21;PALIER;2) in which PALIER is a table
array and it works. I want now to have the "PALIER" changed by getting it
from another cell: =VLOOKUP(C21;C22;2) = i wrote "PALIER" in cell C22....
and that does not work anymore.

Is it a format issue , a table array issue or a Vlookup issue ?

Thanks.
jerome

YES !!! thanks a lot
Jerome

Table array in VLOOKUP (EXcel 2003)
 

The second argument of the VLOOKUP function is a range reference.
What you want it to do is interpret the text in C22 as a range.

Try this:

=VLOOKUP(C21;INDIRECT(C22);2)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"J BRAUD" wrote:

Hi

I use the VLOOKUP formula: =VLOOKUP(C21;PALIER;2) in which PALIER is a table
array and it works. I want now to have the "PALIER" changed by getting it
from another cell: =VLOOKUP(C21;C22;2) = i wrote "PALIER" in cell C22....
and that does not work anymore.

Is it a format issue , a table array issue or a Vlookup issue ?

Thanks.
jerome