| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and display
A C D G
H I J Emp# Code Hours salary regular ot vacation 93 REGSAL 4.00 4.00 0.00 0.00 0.00 93 OVTIME 4.03 4.00 0.00 0.00 0.00 93 REGLAR 7.98 4.00 0.00 0.00 0.00 93 VACTON 8.00 4.00 0.00 0.00 0.00 I'm trying to display the hours worked (column D) in their respective columns (G,H,I,J) but the only column that will display is column G. Here are the formulas I'm using. Salary: IF(VLOOKUP(A2,A:C,3,0)="REGSAL",VLOOKUP(A2,A:D,4,0 ),0) Regular: IF(VLOOKUP(A2,A:C,3,0)="REGLAR",VLOOKUP(A2,A:D,4,0 ),0) OT: IF(VLOOKUP(A2,A:C,3,0)="OVTIME",VLOOKUP(A2,A:D,4,0 ),0) Vacation:IF(VLOOKUP(A2,A:C,3,0)="VACTON",VLOOKUP(A 2,A:D,4,0),0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LookUp to Display Last Value Populated a in Range | Excel Worksheet Functions | |||
| Lookup from range to display a row | Excel Discussion (Misc queries) | |||
| Lookup and Display Using Multiple Criteria | Excel Worksheet Functions | |||
| excel lookup matching and value display | Links and Linking in Excel | |||
| excel lookup matching and value display | Excel Worksheet Functions | |||
Threaded Mode
