Help: Vlookup, Index, Match, or Sumproduct?
 

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

Vlookup, Index, Match, or Sumproduct?
 

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

Vlookup, Index, Match, or Sumproduct?
 

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

Vlookup, Index, Match, or Sumproduct?
 

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