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),

Second sheet is like this ( customer pays)

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.