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

You need to use a combination:

Vlookup/Match

=VLOOKUP(name,lookup_table,MATCH(date,date_range,0 ),0)

Index/Match/Match

=INDEX(lookup_table,MATCH(name,name_range,0),MATCH (date,date_range,0))

Biff

"Phrank" wrote in message
...
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

Excellent! Thank you very much!

On Mon, 12 Feb 2007 23:37:04 -0500, "T. Valko"
wrote:

You need to use a combination:

Vlookup/Match

=VLOOKUP(name,lookup_table,MATCH(date,date_range, 0),0)

Index/Match/Match

=INDEX(lookup_table,MATCH(name,name_range,0),MATC H(date,date_range,0))

Biff

"Phrank" wrote in message
.. .
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

You're welcome!

Biff

"Phrank" wrote in message
...
Excellent! Thank you very much!

On Mon, 12 Feb 2007 23:37:04 -0500, "T. Valko"
wrote:

You need to use a combination:

Vlookup/Match

=VLOOKUP(name,lookup_table,MATCH(date,date_range ,0),0)

Index/Match/Match

=INDEX(lookup_table,MATCH(name,name_range,0),MAT CH(date,date_range,0))

Biff

"Phrank" wrote in message
. ..
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