Hmmm...

I just noticed that your table array is a single row:

=VLOOKUP(8,Details!AB13:CT13,70)

Details!AB13:CT13

Is that a typo?

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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....