P
Phrank
Hi, I'm setting up an overtime metrics worksheet. I have two sheets.
On one sheet I have all employee names in column A and pay dates in
row 1. On Sheet 2, I have the same dates in Row 1, but the names in
column A are simply sorted in a different manner (by work group).
Weekly overtime hours are entered in sheet 1, and I'd like sheet 2 to
simply 'read' the name and date and enter the associated OT hours.
Which would I use, Vlookup, Index, Match, Sumproduct, or a combination
of some of them? Thanks.
Frank
On one sheet I have all employee names in column A and pay dates in
row 1. On Sheet 2, I have the same dates in Row 1, but the names in
column A are simply sorted in a different manner (by work group).
Weekly overtime hours are entered in sheet 1, and I'd like sheet 2 to
simply 'read' the name and date and enter the associated OT hours.
Which would I use, Vlookup, Index, Match, Sumproduct, or a combination
of some of them? Thanks.
Frank