Link to a cell that provides array Name used in vlookup
 

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?

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?