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