Refer to a named range indirectly
 

I'm looking to refer to a named range in a VLOOKUP formula that gets its
value from another cell. In other words, the cell contains a text value that
matches a named range in the workbook and I would like to capture that named
range in a VLOOKUP formula by reference to the cell that contains the named
range value. Hope that is clear enough...

Refer to a named range indirectly
 

Hi,

Nestle the named range in the indirect() function I.e.
=vlookup(look_value,indirect(name),col_index,0)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"tberkom" wrote in message
...
I'm looking to refer to a named range in a VLOOKUP formula that gets its
value from another cell. In other words, the cell contains a text value
that
matches a named range in the workbook and I would like to capture that
named
range in a VLOOKUP formula by reference to the cell that contains the
named
range value. Hope that is clear enough...