Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi All,
We have the following sheets
Sheet1
Sheet2
we want the following result
if Sheet2!A2 will match Sheet1!B2:B3 and Sheet2!C1 date will match Sheet1!A2:A3 then we will get the sum of Sheet1!C2+D2
if Sheet2!A2 will match Sheet1!B2:B3 and Sheet2!C1 date will match Sheet1!A2:A3 then we will get the sum of Sheet1!E2
We have the following sheets
Sheet1
Example (2).xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | d & T | Name | OT | NEW | P/l | ||
2 | 2/20/2018 0:38:52 | Tom Van | 5246 | 65214 | 258 | ||
3 | 2/26/2018 16:47:52 | 65230 | 2547 | ||||
Sheet1 |
Sheet2
Example (2).xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 02-20-2018 | ||||
2 | Tom Van | Test 1 | pass | ||
3 | Test 2 | o.k. | |||
4 | Test 3 | ||||
5 | Test 4 | ||||
6 | Test 5 | ||||
Sheet2 |
we want the following result
if Sheet2!A2 will match Sheet1!B2:B3 and Sheet2!C1 date will match Sheet1!A2:A3 then we will get the sum of Sheet1!C2+D2
if Sheet2!A2 will match Sheet1!B2:B3 and Sheet2!C1 date will match Sheet1!A2:A3 then we will get the sum of Sheet1!E2