Stressed,
The easiest way around this is to put labels onto sheet Texas, cells
E155:V155, where the labels are combinations of whar you are looking for
(within the AND functions) like
CBS12,CBS24,.....CompleteLink60
And then use HLOOKUP
=HLOOKUP(C28&C30,Texas!E155:V156,2,False)
HTH,
Bernie
MS Excel MVP
"Stressed" wrote in message
...
This is the formula im trying to accomplish but xl wont let me nest more
than
seven formulas in one.... any suggestions on what i can do????
=IF(AND(C28="CBS",C30=12),Texas!E156,(IF(AND(C28=" CBS",C30=24),Texas!F156,(I
F(AND(C28="CBS",C30=36),Texas!G156,(IF(AND(C28="Si mpleLink",C30=12),Texas!H1
56,(IF(AND(C28="SimpleLink",C30=24),Texas!I156,(IF (AND(C28="SimpleLink",C30=
36),Texas!J156,(IF(AND(C28="TVD",C30=12),Texas!K15 6,IF(AND(C28="TVD",C30=24)
,Texas!L156,(IF(AND(C28="TVD",C30=36),Texas!M156,( IF(AND(C28="Metro",C30=12)
,Texas!N156,(IF(AND(C28="Metro",C30=24),Texas!O156 ,(IF(AND(C28="Metro",C30=3
6),Texas!P156,(IF(AND(C28="Metro",C30=48),Texas!Q1 56,(IF(AND(C28="Metro",C30
=60),Texas!R156,(IF(AND(C28="CompleteLink",C30=12) ,Texas!S156,(IF(AND(C28="C
ompleteLink",C30=24),Texas!T156,(IF(AND(C28="Compl eteLink",C30=36),Texas!U15
6,(IF(AND(C28="CompleteLink",C30=60),Texas!V156,0) ))))))))))))))))))))))
I know its hefty sorry
|