View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mshaw Mshaw is offline
external usenet poster
 
Posts: 2
Default 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....