Link to a cell that provides array Name used in vlookup

T

Terry

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?
 
M

Mike H

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
 
Top