Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching across multiple worksheets | Excel Worksheet Functions | |||
Matching Multiple Columns | Excel Worksheet Functions | |||
Matching multiple columns | Excel Worksheet Functions | |||
MATCHing through multiple worksheets | Excel Worksheet Functions | |||
Find Matching Data in different columns of different worksheets | Excel Programming |