Howdy Everyone,
I am having difficulty figuring out what terms to search for to get me what I am looking for. I have two sets of input: one is an account list with data colums, and the other is an account list with two columns that I need populated in a specific way based on the account. Words are hard, here is a picture:
in the above example I would want:
account 1's Field_1 to be 4 (Data_a) and Field_2 to be 9 (Data_d)
account 2's Field 1 to be 4 (Data_b) and Field_2 to be 1 (Data_e + Data_a)
in reality my formulas would be more complex than this, but the above is provided for simplicity.
Any help would be really appreciated.
Thank you
