VLookup Question

[bnickelsen]

In the VLookup Funtion =VLOOKUP(ITEM,RANGE,COLUMN,FALSE)

Both Item and column can refer to a cell to pull info.

Can you do the same with Range?

 

[Jason Morin]

Yes, but you need to use INDIRECT to transform it from a
text string to actual range:

=VLOOKUP(---,INDIRECT(E2),---,---)

HTH
Jason
Atlanta, GA

 

[Max]

Yes, but via using INDIRECT()

Assume the table_array is a named range: TBL

You could then have in say,
D1: TBL << table_array
E1: 2 << column index num

and use something like : =VLOOKUP(A1,INDIRECT(D1),E$1,0)
with lookup values in A1 down