Thread: Link to a cell that provides array Name used in vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Link to a cell that provides array Name used in vlookup
To ge a list of all the named ranges select an empty cell and tap F3 and then
Paste List. You can then refer to the appropriate cell.

Mike

"Terry" wrote:

I am trying to use a cell to provide the Name (which defines the array) used
in the vlookup function. This is so that I can run different scenarios. Does
anyone know how to do this?
Reply With QuoteReply With Quote