Thread: Help with vlookup or sumproduct!

Hi,
I can't figure out what code to use to finish my bookkeeping.
I have 3 forms in the same sheet. #1 expenses, #2 Checking Account 1, #3 Checking Account 2.
Basically, I want to add a formula on the forms #2 and #3, so when I add a bill on form #1 and select in which account that money is coming from (#2 or #3) that amount is automatically subtracted from the select account and I can have an updated subtotal.
Thank you very much,
Gustavo

Expenses
A B C
Due Date Amount Method of Payment (dropdown menu)
1
2
3
4
5

Account 1
A B C D
Description Date Amount Subtotal
21
22
23
24
Account 2
A B C D
Description Date Amount Subtotal
31
32
33
34
Basically I will type a new expense and choose from which account that money is coming from i.e. Account 1 or Account 2. Once I choose the account from the drop down menu (Method of Payment) that amount will be automatically subtracted from that specific account updating the subtotal.
Thanks for your help,
Gustavo