So I’m using Google Sheets for some finance stuff. I have two sets of data, both with two columns. The first set is a total account balance and dates, and the second is a list of deposits and dates. I want to be able to match each date in the second to a date in the first, then subtract the corresponding amounts.

Example being as follows:
1/1/2024 | 100
1/2/2024 | 120
1/3/2024 | 140
And
1/1/2024 | 10
1/3/2024 | 20

So the second data sheet doesn’t have the same date range as the first data sheet, it’s more of a subset of the date range of the first sheet. Would there be some way for the first sheet’s third column to have some function that can search the second sheet for a date, and if it matches, take the corresponding amount and subtract it from the corresponding amount in the first sheet?

I tried using some features like if functions but I honestly have no clue how to make it read an entire range and then extract the data.