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.
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.