Multiple LOOKUP requirements... I have a relatively large spreadsheet that chang

Question

Multiple LOOKUP requirements...

I have a relatively large spreadsheet that changes frequently (weekly). I wanted to create an easy way to populate the correct pay rates based on the pay code associated with each employee. It would need to first look at the pay code next to the employee's name in column E, then at the pay type in column F (ie: regular time, over time, double time), then find those two values in another sheet "RATES" and return the pay rate associated with those two criteria to column H.

Example:

WORKSHEET 1 - "COMBINED"

WORKSHEET 2 - "RATES"

Any help is MUCH appreciated!

A B C D E F G H Code Phase GL Date Employee Class Date Type Rate FAB/PSSS 00-004 08/31/14 JOSEPH ALBERTSON JRNY 08/25/14 Reg FAB/PSSS 00-004 08/31/14 JOSEPH ALBERTSON JRNY 08/26/14 OT FAB/PSSS 00-004 08/31/14 CHRISTINE BEAUCHAM FRMN 08/26/14 Reg FAB/PSSS 00-004 08/31/14 CHRISTINE BEAUCHAM FRMN 08/27/14 Reg FAB/PSSS 00-004 08/31/14 ALBERT CHAMP APP 08/27/14 OT FAB/PSSS 00-004 08/31/14 ALBERT CHAMP APP 08/28/14 Reg FAB/PSSS 00-004 08/31/14 JUSTIN DUGAN GF 08/29/14 Reg FAB/PSSS 00-004 08/31/14 JUSTIN DUGAN GF 08/28/14 OT FAB/PSSS 00-006 08/31/14 BOB EDWARDS SUPER 08/26/14 Reg FAB/PSSS 00-008 08/31/14 BOB EDWARDS SUPER 08/28/14 DT

Explanation / Answer

Hi,

with your data in sheet1 in the range A1:H11

and in range A1:D6 in sheet2

Try this:

=INDEX(Sheet2!$A$1:$D$6,MATCH(E2,Sheet2!$A$1:$A$6,0),MATCH(G2,Sheet2!$A$1:$D$1,0))

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.