# Problem w/vlookup

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.

S

#### Sean Timmons

=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,O110,2,0)),VLOOKUP(D55,L3:M13,2,0)),VLOOKUP(D55,H3:I13,2,0))

J

#### John C

=IF(OR(D55="",D55=0),"",IF(D55<11,VLOOKUP(D55,H3:I13,2,FALSE),IF(D55<21,VLOOKUP(D55,L3:M13,2,FALSE),VLOOKUP(D55,O39,2,FALSE))))

Hope this helps.

J

#### John C

I am also assuming with my formula that D55 has data validation to limit it
to valid entries of nothing (or 0) to 25 in whole numbers.

S

#### Sandy

Thank you so much for your time and effort. The formula works perfectly.

J

#### John C

Thanks for the feedback
--
John C

Sandy said:
Thank you so much for your time and effort. The formula works perfectly.