VLOOKUP where a cell specifies the table array

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

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



Hall wrote:
>
> 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

--

Dave Peterson

Thanks. That works
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> =vlookup(A1, indirect(B2), 2, false)
>
>
>
> Hall wrote:
>>
>> 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
>
> --
>
> Dave Peterson