Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP with 2 Conditions
Hello,
Sheet 1 is the Data and Sheet 2 is the result I need. Sheet 1: (DATA) A B 1 GROUP 1 Hours:Minutes 2 **HOLIDAY 421:35 3 ~SHIFT 4560:25 4 OT 851:43 5 *UNDERTIME 48:52 6 GROUP 2 Hours:Minutes 7 SHIFT 3821:56 8 OT 450:21 9 *VACATION 68:25 SHEET 2 (Result) A B C 1 SEGMENTS GROUP 1 GROUP 2 2 SHIFT 4560:25 3821:56 3 OT 851:43 450:21 4 HOLIDAY 421:25 0 5 VACATION 0 68:25 6 UNDERTIME 48:52 0 How can I use VLOOKUP to get the result I need? I actually have 20 Groups and have different segments in each group. Is there other formula I can use? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with conditions | Excel Worksheet Functions | |||
Vlookup with conditions | Excel Worksheet Functions | |||
VLOOKUP with 2 conditions | Excel Discussion (Misc queries) | |||
Vlookup with 3 or more conditions | Excel Worksheet Functions | |||
How do you do a VLookup with two conditions? | Excel Worksheet Functions |