=IF(ISNA(VLOOKUP(D55,H3:I13,2,0)),IF(ISNA(VLOOKUP( D55,L3:M13,2,0)),IF(ISNA(VLOOKUP(D55,H3:I13,2,0)), "Not
found",VLOOKUP(D2,O1:P10,2,0)),VLOOKUP(D55,L3:M13, 2,0)),VLOOKUP(D55,H3:I13,2,0))

"Sandy" wrote:

I have created a employee absentee form. In comment area, want to type in
number from range that automatically types in description from same range.

=IF(OR(VLOOKUP(D55,(H3:I13),2,FALSE)),(VLOOKUP(D55 ,(L3:M13),2,FALSE)),(VLOOKUP(D55,(O3:P9),2,FALSE)) )


SUMMARY OF COMMUNICATION:
Date Code Reason
1/1/08 A 10 #VALUE!


H I L M
O P

No. Reason No. Reason No. Reason
1 Accident - Self or family 11 Injury on Job 22 Weather
12 Jury Duty/Court 23 Work Comp-Hours
2 Comp. Time 13 Leave w/o pay
3 Death in Family 14 Medical Appt. 24 Work Comp-Sick
4 Disaster 15 Military
5 Discipline 16 Personal 25 Work Comp-Vacation
6 Family Sickness 17 Shared Leave
7 Floating Holiday 18 Sick (employee)
8 FMLA-Leave w/o pay 19 Suspended w/Pay
9 FMLA-Sick 20 Transportation
10 FMLA-Vacation 21 Unknown
I thought I could use an if then statement, but that was from back when I
did formulas in spreadsheet in 80's.

Any help would be appreciated.