Try it like this:

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

--
Biff
Microsoft Excel MVP


"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....