matching multiple columns on different worksheets
 

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.


--
Bob

matching multiple columns on different worksheets
 

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

"Bob" skrev i meddelelsen
...
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.


--
Bob