Except that it looks up the second but last cell, if you want the last cell
in AB13:CT13 you should change 70 to 71


--


Regards,


Peo Sjoblom


"Mshaw" wrote in message
...
Thank You....

I think I tried every possible iteration of quotes, except the one you
showed. The post was correct using a single row with Vlookup, maybe I
could
have done it differently, but what I'm looking for is whether or not there
is
an 8 in the first cell and if there is then I return the value from the
last
cell of the array. The Vlookup is in an IF statement that returns null if
there is not an 8 in that first cell.

Everything in the worsheet is tied to a single cell that has a date, I can
change the date and all the references change, including the column # to
return at the end of the vlookup statement, which I showed as a constant
in
the original post.

Mike

"T. Valko" wrote:

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