=VLOOKUP(8,Details!INDIRECT(B11):CT13,70)

Excel won't accept that as a formula. You have to put the entire table array
*inside* the INDIRECT function.

=VLOOKUP(8,INDIRECT("Details!"&B11&":CT13"),70)

But even this formula doesn't make sense since the table array is a single
row.

--
Biff
Microsoft Excel MVP


"Wondering" wrote in message
...
If B11 contains the starting cell of the array (AB13) you can use
=VLOOKUP(8,Details!INDIRECT(B11):CT13,70) and the formula becomes
=VLOOKUP(8,Details!AB13:CT13,70)


"Mshaw" wrote in message
...
I need to reference only the first cell of an array on a different
worksheet
using a value in a cell on the current worksheet:

Current Worksheet
Cell B11 contains text from another function which is a cell reference
i.e
AB13

I am trying to create a VLookup array on a different worksheet:
=VLOOKUP(8,Details!AB13:CT13,70)

I know I need to somehow replace the AB13 with &B11, but I cannot get it
to
work correctly.

Thanks for the help....