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,(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.
 
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,O1:p10,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,O3:p9,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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top