'grabbing' a sum from a separate table

[AbbeyMetal]

Im new to excel and i am wanting to have two different tables. one with my bank balances and the total for each day and in the other i have my bills. im wanting to see how much i have available on each day without having to go back and forth between tables. i can manually plug in a formula that grabs the number specific to the day im on but i want it to be autonomous. every day i check my bank accounts to see how much i have available and i enter the values daily. i want excel to read 'if theres a bill with a date the same as the statement, then display the bank balance in this row, else 0.' any ideas on making this work? Thanks