View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ronin Ronin is offline
external usenet poster
 
Posts: 17
Default Vlookup - using a cell to reference a named array

I have a file that contains several options for the named table array. In a
menu the user identifies what the criteria is and this drives lookups to
determine the name of the array. I am then using this cell reference in my
vlookup. However it appears the formula will not accept a cell reference for
a named array. Does anyone have another solution?
=VLOOKUP(D9,F5,12,FALSE)

where F5 is a calculated value for the table named table array.
thanks