excel formula depends upon 3 set of value result from set of range lookup

[breadwinner]

dear expert

I HAVE DATA IN 4 COLUMN CONTINUSLY BUT I WANT MY CALCULATE SHOULD OCCUR ONLY WITH 3COLUMN DEPENDS.

I HAVE ARRANGE AGING FOR CALCULATEION WITH BUSINESS AND STATUS
I HAVE AGING IN TWO COLUMN COMMITTED AND NON COMMITED


ZSP1-YES- COMMITTED RESULT 1 OR 2 OR 3
ZLAB-YES-NON COMMITED RESULT 1 OR 2 OR 3
BRING-YES-NON COMMITTED RESULT 1 OR 2 OR 3


IF ZSP1 IN COLUMN B:B THEN YES IN COLUMN C:C THEN SHOULD CHECK AGING IN D:D COLUMN " COMMITTED " WITH THE AGING IF > 30 DAYS RESULT SHOULD BE 1, 21-30 DAYS RESULT SHOULD BE 1, ,IF 11-20 DAYS RESULT SHOULD BE 2,IF 6-10 DAYS RESULT SHOULD BE 2, IF 3-5 DAYS RESULT SHOULD BE 2, IF 0-2 DAYS RESULT SHOULD BE 3....

IF ZLAB IN COLUMN B:B THEN YES IN COLUMN C:C THEN SHOULD CHECK AGING IN E:E COLUMN " NON COMMITTED " WITH THE AGINGIF ZSP1 IN COLUMN B:B THEN YES IN COLUMN C:C THEN CHECK AGING IN D:D COLUMN " COMMITTED " WITH THE AGING IF > 30 DAYS RESULT SHOULD BE 1,OR ,IF 21-30 DAYS RESULT SHOULD BE 1,OR ,IF 11-20 DAYS RESULT SHOULD BE 2,OR,IF 6-10 DAYS RESULT SHOULD BE 2, OR ,IF 3-5 DAYS RESULT SHOULD BE 2,OR, IF 0-2 DAYS RESULT SHOULD BE 3........

IF BRING IN COLUMN B:B THEN YES IN COLUMN C THEN SHOULD CHECK AGING IN E:E COLUMN " NON COMMITTED " WITH THE AGING IF ZSP1 IN COLUMN B:B THEN YES IN COLUMN C:C THEN CHECK AGING IN D:D COLUMN " COMMITTED " WITH THE AGING IF > 30 DAYS RESULT SHOULD BE 1,OR ,IF 21-30 DAYS RESULT SHOULD BE 1,OR ,IF 11-20 DAYS RESULT SHOULD BE 2,OR,IF 6-10 DAYS RESULT SHOULD BE 2, OR ,IF 3-5 DAYS RESULT SHOULD BE 2,OR, IF 0-2 DAYS RESULT SHOULD BE 3....

CHECK THE ATTAHMENT IT WILL BE EASY UNDERSTANDING THAN MY BRIEF QUTATION