Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem w/vlookup
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup problem | Excel Discussion (Misc queries) | |||
Vlookup problem | Excel Worksheet Functions | |||
Vlookup problem | Excel Worksheet Functions | |||
VLOOKUP problem with using a - | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Discussion (Misc queries) |