VLOOKUP where a cell specifies the table array

H

Hall

I want to use vlookup where the table array I'm looking up is actually
specified in a cell.

This is what I want:
=vlookup(A1, B2, 2, false)

where B2 has the value "A10:A20"

What is the syntax or construct for this?

Thanks so much
 
D

Dave Peterson

=vlookup(A1, indirect(B2), 2, false)


I want to use vlookup where the table array I'm looking up is actually
specified in a cell.

This is what I want:
=vlookup(A1, B2, 2, false)

where B2 has the value "A10:A20"

What is the syntax or construct for this?

Thanks so much
Click to expand...
 
Top