About Us

suraneniaditya

May be yes. but the result is not a single value it is a named range ( each range contains the details of tax payments relating to various tax payers. which looks as follows.

Sl No Name Tax ID No Field 1 Field 2 Field 3 Field 4 Field5
1 JOY 5454
2 JOY 5454
3 JOY 5454

the other details like subtotals are to be summarised in to a seperate template. to be precise this range of data should be returned as an annexure giving the detailed breakup of the total summary on top.

I tried IF(B2="JOY",JOY,0) nested for 7 names and entered as an array formula. This is working only for 7 names. but there are hundreds more.

Pls help me

Adi

Quote:

Originally Posted by Max

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup to return blank cell if nothing in range	Haz	Excel Discussion (Misc queries)	2	April 15th 08 08:22 PM
Can VLookup return the LAST value in a range?	Steve	Excel Worksheet Functions	3	December 17th 07 05:18 PM
Vlookup to Return a Range of Data	James	Excel Discussion (Misc queries)	0	July 13th 06 09:44 PM
Vlookup to Return a Range of Data	Rob	Excel Discussion (Misc queries)	13	June 1st 06 04:02 AM
How do I sum a range which includes the "#N/A" VLOOKUP return valu	Sailor	Excel Worksheet Functions	6	May 9th 05 08:46 AM

Menu

About Us