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.

Posted by Big bob on March 23, 2001 8:29 AM

Have you tried using the function wizard and or help for the INDIRECT function
It sounds like it would be suitable

Posted by Aladin Akyurek on March 23, 2001 9:14 AM

=vlookup(1,indirect(b3),3), as Marcus suggested.

Posted by Marcus Henderson on March 23, 2001 10:19 AM

Thanks. Simple, but effective...