S
Sandy
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,(O39),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.
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,(O39),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.