matching multiple columns on different worksheets

B

Bob

I have two worksheets with the same information in columns A,B and C. My
second worksheeet has hours worked in Column D. What I would like to do is
have a formula that states if columns A B and C are equal in both tables to
have the result in column D in my seocnd table to appear in column P of my
first table.
For Example:

if A2 Worksheet1 = A2 Worksheet2
if B2 Worksheet1 = B2 Worksheet2
if C2 Worksheet1 = C2 Worksheet2
then put amount in D2 Worksheet2 in cell P2 of Worksheet1.

Thanks.
 
P

Per Jessen

Hi Bob

Enter this formula in P2 of sheet1.

=IF(Sheet1!A2=Sheet2!A2,IF(Sheet1!B2=Sheet2!B2,IF(Sheet1!C2=Sheet2!C2,Sheet2!D2)),"")

Regards,
Per
 

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