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!