| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem w/vlookup
=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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem w/vlookup
=IF(OR(D55="",D55=0),"",IF(D55<11,VLOOKUP(D55,H3:I 13,2,FALSE),IF(D55<21,VLOOKUP(D55,L3:M13,2,FALSE), VLOOKUP(D55,O3:P9,2,FALSE))))
Hope this helps. -- John C "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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem w/vlookup
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. -- John C "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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem w/vlookup
Thank you so much for your time and effort. The formula works perfectly.
"John C" wrote: 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. -- John C "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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problem w/vlookup
Thanks for the feedback :)
-- John C "Sandy" wrote: Thank you so much for your time and effort. The formula works perfectly. "John C" wrote: 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. -- John C "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. |
| Reply |
| 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) | |||
Linear Mode
