need help with formula lookups

[trey]

please take a look at for me.. i think im missing some
scripting in the formula...

=IF(E13="","","Group "&INDEX(SUMMIT!B19:B61,MATCH
(E13,SUMMIT!C19:C61,0),IF(E13="","","Group"&INDEX(MATRIX!
A10:A31,MATCH(E13,MATRIX!B10:B31,0)))))
**** i added the scripting group:2nd if-index matrix--
before that it was working...

=IF(D13="GROUP 1",VLOOKUP(E13,SUMMIT!C19:K23,MATCH
(G13,SUMMIT!C18:K18,0),0),IF(D13="GROUP 5",VLOOKUP
(E13,SUMMIT!C57:G61,4,0),IF(D13="GROUP 4",VLOOKUP
(E13,SUMMIT!C50:H54,4,0),IF(D13="GROUP 7",VLOOKUP
(E13,MATRIX!B10:H25,MATCH(G13,MATRIX!C9:H13,0),"")))))

=IF(D13="GROUP 1",VLOOKUP(E13,SUMMIT!C26:K30,MATCH
(G13,SUMMIT!C25:K25,0),0),IF(D13="GROUP 5",VLOOKUP
(E13,SUMMIT!C57:G61,5,0),IF(D13="GROUP 4",VLOOKUP
(E13,SUMMIT!C50:H54,5,0),IF(D13="GROUP 7",VLOOKUP
(E13,MATRIX!B16:H25,MATCH(G13,MATRIX!C14:H19,0),"")))))

=IF(D13="GROUP 1",VLOOKUP(E13,SUMMIT!C33:K37,MATCH
(G13,SUMMIT!C32:K32,0),0),IF(D13="GROUP 5",VLOOKUP
(E13,SUMMIT!C57:G61,3,0),IF(D13="GROUP 4",VLOOKUP
(E13,SUMMIT!C50:G54,3,0),IF(D13="GROUP 7",VLOOKUP
(E13,MATRIX!B22:H25,MATCH(G13,MATRIX!C20:H25,0)"")))))

=IF(D13="GROUP 3",VLOOKUP(E13,SUMMIT!C40:J44,MATCH
(G13,SUMMIT!C39:J39,0),0),IF(D13="GROUP 4",VLOOKUP
(E13,SUMMIT!C50:H54,6,0),IF(D13="GROUP 8",VLOOKUP
(E13,MATRIX!B28:H31,MATCH(G13,MATRIX!C26:H31,0)"")))

on these 4 i added the script : group 7 & 8--- again
before that it was working---trying to add additional
functions...
plz help
trey

 

[Frank Kabel]

Hi
looks like you have hit the maximum of nested functions in Excel (which
is seven).

 

[trey]

i should only be at 6 functions...
when the groups were set up they were :
1,3,4,5,7,8... 2 and 6 were skipped over.. by skipping
over has that created a conflict?
trey