Array reference using indirect address
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....
|