Hello,

I have 2 sheets. In sheet A I have 50,000 Bank transactions on Column A and their dates on Column B and in Sheet B I have about 1000 transactions in column A and their dates on Column B. I want to see, for example, whether $10 on Jan 3, 2022 from sheet B was refunded to me in Sheet A or not. To do so, I can do a manual search in sheet A and find all the results matching the $10 deposit, and see if any of them happened on Jan 3, 2022 or not.

Is there a formula I can use instead of checking every single 1000 entry manually?

Thanks