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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
if A1 houses the name of your range try something like:
=VLOOKUP(B1,INDIRECT(A1),2,0)
 
Back
Top