Help: Vlookup, Index, Match, or Sumproduct?

[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

 

[T. Valko]

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]

Excellent! Thank you very much!

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

 

[T. Valko]

You're welcome!

Biff

Excellent! Thank you very much!