Help: Vlookup, Index, Match, or Sumproduct?

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
 
T

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top