View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tberkom tberkom is offline
external usenet poster
 
Posts: 2
Default Refer to a named range indirectly

I'm looking to refer to a named range in a VLOOKUP formula that gets its
value from another cell. In other words, the cell contains a text value that
matches a named range in the workbook and I would like to capture that named
range in a VLOOKUP formula by reference to the cell that contains the named
range value. Hope that is clear enough...