I have 2 excel sheets, first one is the value I expected from a customer. The second one is what customers pays me. I want to check if customer paid me as I expected.
Here is an important note, I have a tolerance which is -10, +10. I mean in the table below I can accept price range from 529 to 549 (in the example I can’t accept because price is 519 which is out of my range).
The important thing is, datas are in completely different order.
First sheet is like this ( what I expect),
ID | Date | Category | Price | ** |
---|---|---|---|---|
12345678910 | 01/2024 | 20 | 539 | |
34561234516 | 01/2024 | 20 | 123456,50 |
Second sheet is like this ( customer pays)
ID | Date | Category | Price | ** |
---|---|---|---|---|
345612346516 | 01/2024 | 20 | 12344,50 | |
12345678910 | 01/2024 | 20 | 519 |
I have 2 excel sheets, first one is the value I expected from a customer. The second one is what customers pays me. I want to check if customer paid me as I expected.
When I match them I want to write “ok” to next column.
What I have tried; VLOOKUP is just bringing me the first data therefore If there are duplicates I cannot match them. I tried INDEX but also doesn’t work.