Referencing range name from another cell
Posted by Marcus Henderson on March 23, 2001 7:58 AM
I am trying to write a vlookup formula that references a range name. The range name needs to be located in a cell. I want the vlookup function to get the range name from this cell.
For example cell b3 contains the range name 'range1'. The correct vlookup is VLOOKUP(1,range1,3). I want to write it this way: VLOOKUP(1,cellvalue(B3),3). If I write the function cellvalue, how can I get it to return range1 without any quotes so it will work in the formula?
Thanks for your help.