Try INDIRECT
eg in say, C2:
=VLOOKUP(B2,INDIRECT(A2),2,0)
where A2 contains the named range
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Allan" wrote:
I have created a named range. I use the name of the range as the second
argument in the vlookup function and the function works fine.

I would like to replace the name of the range with a cell reference. The
cell being referred to indicates the name of the range. When I do this, the
function ceases to work.

Can this be done?