referencing a dropdown option that populates a formula

Hi

I'll be brief since this system has already deleted my post once.....gr

I have 5 columns
e - debits
f - credits
g - column - with drop down (validity) with 4 options (accounts)
j - account 1 from drop down
k - account 2 from drop down

J and K are accounts that I am keeping a running balance on, but they are separate from each other

what i need is:

when i select an option from the drop down in G, (if its options 3 or 4 - nothing happens on the spread sheet, cells stay empty) and I choose option J/the words that correspond with J then in column J I want this formula to populate/function (=J4+E8-F8) and for column K to remain empty.

Conversely if I choose option K/words that correspond with K from the drop down in column G then in column K I want this formula to populate/function (=K4+E8-F8) and for column J to remain empty.


Hopefully that all makes sense & is possible. Correct J & K formula's as need (obviously )
thank you! I appreciate it!

Let me know if you need more on the purpose of the spreadsheet

thanks guys.

after starring at it for so long its hard to know what is clear and what isnt anymore.
it's my kids birthday tonight, but i will definitely copy up a sample sheet and submit it back in the next few days. i appreciate your help and try to clarify more what i need.
thank you so much for you help!