vlookup question

[darkmidget]

Hi,



I am wondering if you can have the table array portion of the vlookup formula link to another cell. For example: I want the formula to be =vlookup(A1,C1,2) C1 would be one of 3 different defined names to different ranges. Is this possible and if so can you point me in the right direction?


Thanks,

Matt

 

[Derek]

Hi there
You could try use INDIRECT(C1)
regards
Derek

 

[IML]

--------> =vlookup(A1,indirect(C1),2)

 

[darkmidget]

That was it! Thank you!

 

[RichardS]

Try

=VLOOKUP(A1,INDIRECT(C1),2)

where C1 contains your range name.

Richard

EDIT: Too slow by far

_________________

This message was edited by RichardS on 2002-10-21 20:55

 

[Aladin Akyurek]

On 2002-10-21 20:46, darkmidget wrote:
Hi,



I am wondering if you can have the table array portion of the vlookup formula link to another cell. For example: I want the formula to be =vlookup(A1,C1,2) C1 would be one of 3 different defined names to different ranges. Is this possible and if so can you point me in the right direction?


Thanks,

Matt

Matt,

With 3 different names, you could get away with IF...

=VLOOKUP(A1,IF(C1="Name1",Name1,IF(C1="Name2",Name2,Name3)),2)