Hello,

I am working on a very challenging spreadsheet at the moment.

On Book1 I have the previous month data and the amount that people owed. On Book2 I have the other amount and some of them started in a different date. On a sheet2 I want the different amount that people owe for this month. So I need a formula that will check the date, and the name on Sheet1, and them check if it is matching with Book1.

I have tried a if statement, but it will be based by cells and not by the data.

Anyone else have any ideas?

Thanks!