Hi all
I trying to do a cross check data based on criteria is Sheet1. Sheet2 contained my raw database data. How to compile an excel function using sumproduct to do it. The criterias in Sheet1 is A2 & C2. The formula shall be in D1 showing the extract data which is B2 from Sheet2.
Can anyone help
The sample data as follow:
Sheet1
A B C D
1 Postal Code Fee Mobile Cross-Chk
2 123456 50 11112222 50
3 222333 30 10102020 20
4 444555 10 13131414 10
Sheet2
A B C D
1Postal Code Fee Mobile
2 123456 50 11112222
3 222333 20 10102020
4 444555 10 13131414
From Sheet1 D2 to D4, I can know that B3 is not the same as D3 which I need to check out the postal code 222333 with my supplier.
Cheers
I trying to do a cross check data based on criteria is Sheet1. Sheet2 contained my raw database data. How to compile an excel function using sumproduct to do it. The criterias in Sheet1 is A2 & C2. The formula shall be in D1 showing the extract data which is B2 from Sheet2.
Can anyone help
The sample data as follow:
Sheet1
A B C D
1 Postal Code Fee Mobile Cross-Chk
2 123456 50 11112222 50
3 222333 30 10102020 20
4 444555 10 13131414 10
Sheet2
A B C D
1Postal Code Fee Mobile
2 123456 50 11112222
3 222333 20 10102020
4 444555 10 13131414
From Sheet1 D2 to D4, I can know that B3 is not the same as D3 which I need to check out the postal code 222333 with my supplier.
Cheers