I HAVE A MASTER SHEET WITH DATA. IF CELL A4 SAYS SET A THEN THE DATA IN
D2 IS LINKED TO NGV 1_TEST SHEET SET A. IF IT SAYS SET B THEN SET B AND
SO ON. HOWEVER THIS VALUE MAY GO UPTO SET O THEN IT SHOULD GO TO SHEET
SET O. BECAUSE OF THE LIMITATION OF ONLY 7 NESTED LOOPS, HOW DO I GO
ABOUT DOING THIS? THE FORMULA I USED IS BELOW:


=IF('Unit CT #3'!$B$4="Set A",'[NGV 1_test.xls]Set A'!$D$2,IF('Unit CT
#3'!$B$4="Set B",'[NGV 1_test.xls]Set B'!$D$2,IF('Unit CT #3'!$B$4="Set
C",'[NGV 1_test.xls]Set C'!$D$2,IF('Unit CT #3'!$B$4="Set D",'[NGV
1_test.xls]Set D'!$D$2,IF('Unit CT #3'!$B$4="Set E",'[NGV
1_test.xls]Set E'!$D$2,IF('Unit CT #3'!$B$4="Set F",'[NGV
1_test.xls]Set F'!$D$2,IF('Unit CT #3'!$B$4="Set G",'[NGV
1_test.xls]Set G'!$D$2,IF('Unit CT #3'!$B$4="Set H",'[NGV
1_test.xls]Set H'!$D$2,""))))))))


--
ashcrusher
------------------------------------------------------------------------
ashcrusher's Profile: http://www.excelforum.com/member.php...o&userid=29681
View this thread: http://www.excelforum.com/showthread...hreadid=500967