how do i assign the contents of a cell to a range name

T

tenswg

Using the vlookup command it would be useful to be able to change the range
name of the data by having it assigned from a cell
 
F

Frank Kabel

Hi
if A1 houses the name of your range try something like:
=VLOOKUP(B1,INDIRECT(A1),2,0)
 
Top