Maybe you meant something like this:
=VLOOKUP(A2,INDIRECT(B2),2,0)
where B2 is the DV cell to select the named range
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"suraneniaditya" wrote in message
...

Dear all

I have a sheet with as many as 50 named ranges in sheet 1. These names
are in a drop own list put in data validation in sheet 2.

I need to get the entire range to be returned for the name selected in
the drop down.

For eg: If I select JOHN in the drop down I Should get the range named
JOHN (which may be of 8C X 12R dimension).

I have tried IF & Vloookup combination entered as an array formula but
it is working upto 7 names only. Please help me..

Thanks




--
suraneniaditya