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,(IF(AND(C28="CBS",C30=36), Texas!G156,(IF(AND(C28="SimpleLink",C30=12),Texas! H156,(IF(AND(C28="SimpleLink",C30=24),Texas!I156,( IF(AND(C28="SimpleLink",C30=36),Texas!J156,(IF(AND (C28="TVD",C30=12),Texas!K156,IF(AND(C28="TVD",C30 =24),Texas!L156,(IF(AND(C28="TVD",C30=36),Texas!M1 56,(IF(AND(C28="Metro",C30=12),Texas!N156,(IF(AND( C28="Metro",C30=24),Texas!O156,(IF(AND(C28="Metro" ,C30=36),Texas!P156,(IF(AND(C28="Metro",C30=48),Te xas!Q156,(IF(AND(C28="Metro",C30=60),Texas!R156,(I F(AND(C28="CompleteLink",C30=12),Texas!S156,(IF(AN D(C28="CompleteLink",C30=24),Texas!T156,(IF(AND(C2 8="CompleteLink",C30=36),Texas!U156,(IF(AND(C28="C ompleteLink",C30=60),Texas!V156,0))))))))))))))))) ))))))

I know its hefty sorry