Can a formula do this?

[otisjames]

This is what I have...

20 different accounts
for each account there is column of data
each column includes:
List A
List B
List C

I would like to be able to select the account and in a cell put in a number that will coordinate with List A. If that number is too low, I would like it to return "Exception". Then, I would put in a number that would coordinate with List A and B. If that number is found on List A and List B, then it should return "OK" if not than "Exception". The same for list C. This is extremly confusing to me as well as all those reading it. I have the formatting I want I just need a formula to "think" for me and make the process automatic. Does anyone have any suggestions?

 

[SIXTH SENSE]

hi!
what are list A etc.?

 

[otisjames]

1-4 Family Owner Occupied Non-Purchase 1st Lien Position (<=5 yrs) 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
1-4 Family Owner Occupied Non-Purchase 1st Lien Position (6-10 yrs) 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
1-4 Family Owner Occupied Non-Purchase 1st Lien Position (11-15 yrs) 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
1-4 Family Non-Owner Occupied Non-Purchase 1st Lien Position 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
1-4 Family Owner Occupied Non-Purchase 2nd Lien Position (<=5 yrs) 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
1-4 Family Owner Occupied Non-Purchase 2nd Lien Position (6-10 yrs) 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
1-4 Family Owner Occupied Non-Purchase 2nd Lien Position (11-15 yrs) 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
1-4 Family Non-Owner Occupied Non-Purchase 2nd Lien Position 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
Owner Occupied 1-4 Family Purchase 1st Lien Position 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
Owner Occupied 1-4 Family Non-Purchase 1st Lien Position 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
Non-Owner Occupied 1-4 Family Purchase-Non-Purchase 1st Lien Position 680-699 75% max 55%
700 & above 80% max 50%
700 & above 90% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
Vacant Land 1st Lien Position 680-699 50% max 55%
700 & above 60% max 50%
700 & above 65% max 45%
680-699 65% max 40%
650-679 65% max 36%
620-649 50% max 36%
Titled Manufactured Homes with land-single wide 1st Lien Position 700 & above 80% max 42%
620-699 75% max 36%
700 & above 80% max 42%
620-699 75% max 36%
1-4 Family Owner Occupied Construction (Contractor Built) 1st Lien 620 & above 80% max 40%
1-4 Family Owner Occupied Construction (Owner Built) 1st Lien 620 & above 80% max 40%
(adj) Titled manufactured Homes with land- Single wide (1st Lien) 680-699 75% max 55%
700 & above 80% max 45%
680-699 75% max 40%
650-679 75% max 36%
620-649 75% max 36%
(adj) 1-4 Family Owner Occupied Non- Purchase 1st Lien Position 680-699 75% max 55%
700 & above 50% max 50%
700 & above 80% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
(adj) 1-4 Family Owner Occupied Non- Purchase 2nd Lien Position 680-699 75% max 55%
700 & above 50% max 50%
700 & above 80% max 36%
680-699 80% max 40%
650-679 80% max 35%
620-649 80% max 36%
(adj) 1-4 Family Owner Occupied Purchase 1st Lien Position (Subject to floor) 680-699 75% max 55%
700 & above 50% max 36%
700 & above 80% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
(adj) 1-4 Family Owner Occupied Non-Purchase 1st Lien Position (Subject to floor) 680-699 75% max 55%
700 & above 50% max 36%
700 & above 80% max 36%
680-699 80% max 40%
650-679 80% max 36%
620-649 80% max 36%
(adj) 1-4 Family Non-Owner, Non-Purchase 1st Lien Position (Subject to floor) 680-699 65% max 55%
700 & above 90% max 36%
700 & above 90% max 36%
680-699 90% max 40%
650-679 75% max 36%
620-649 70% max 36%
(adj) Home Equity Lines of Credit 1st Mortgage Owner Occupied 700 & above 90% max 36%
700 & above 80% max 36%
650-724 80% max 42%
620-649 75% max 36%
(adj) Home Equity Lines of Credit 2nd Mortgage Owner Occupied 700 & above 90% max 36%
725 & above 80% max 36%
650-724 80% max 42%
620-649 75% max 36%
(adj) Home Equity Lines of Credit 1st Mortage Non-Owner Occupied 700 & above 80% max 36%
650-724 75% max 42%
620-649 70% max 36%
(adj) Home Equity Lines of Credit 2nd Mortage Non-Owner Occupied 700 & above 80% max 36%
650-724 75% max 42%
620-649 70% max 36%
(adj) Titled manufactured Homes with land- double wide 680-699 75% max 55%
700 & above 80% max 45%
650-679 75% max 36%
620-649 75% max 36%
Loans secured by lawn equipment/ATV/Motorcycles/Non-Titled equipmennt 700 & above N/A 42%
680-699 N/A 42%
650-679 N/A 42%
620-649 N/A 36%
Unsecured-fixed 700& above N/A 42%
680-699 N/A 42%
650-679 N/A 42%
620-649 N/A 36%

This is my lists of data. I would like to be able to pick an account and put in a number that would go along with the 700& above lists. If that number is not OK then it should return "violation". Then I would put in the 2nd # and it should see if it's ok. Does any of this make sense? [/list]