Nested Loop Link

A

ashcrusher

I HAVE A MASTER SHEET WITH DATA. IF CELL A4 SAYS SET A THEN THE DATA I
D2 IS LINKED TO NGV 1_TEST SHEET SET A. IF IT SAYS SET B THEN SET B AN
SO ON. HOWEVER THIS VALUE MAY GO UPTO SET O THEN IT SHOULD GO TO SHEE
SET O. BECAUSE OF THE LIMITATION OF ONLY 7 NESTED LOOPS, HOW DO I G
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 C
#3'!$B$4="Set B",'[NGV 1_test.xls]Set B'!$D$2,IF('Unit CT #3'!$B$4="Se
C",'[NGV 1_test.xls]Set C'!$D$2,IF('Unit CT #3'!$B$4="Set D",'[NG
1_test.xls]Set D'!$D$2,IF('Unit CT #3'!$B$4="Set E",'[NG
1_test.xls]Set E'!$D$2,IF('Unit CT #3'!$B$4="Set F",'[NG
1_test.xls]Set F'!$D$2,IF('Unit CT #3'!$B$4="Set G",'[NG
1_test.xls]Set G'!$D$2,IF('Unit CT #3'!$B$4="Set H",'[NG
1_test.xls]Set H'!$D$2,"")))))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup two different variables 0
Filtering data 2
Returning 1 of 4 values if conditions are met 4
Help with lots of formulas 3
Sumproduct? 3
Excel VBA macro, search - accumulate - delete original 0
Counting cells with SUMPRODUCT and conditionals...? 1
Help with column accumulation needed 2

Top