I am attempting to find a solution to perform calculations based on 2 tables. It's difficult for me to explain, so I have screenshots to show what I am trying to accomplish. The final base table will contain 1,000s of combinations to perform calculations from.
Base table
Lookup table
The field I called "Add values" contains the values that need to be added together from the values inthe lookup table. The screenshot is a very small sample. The lookup table will contain about 100 lookup columns.
So, for the V-A combo 20069-130115, the "Add values" field would be the sum of the lookup values for those fields, which would result in this calculation
=309,619.139
I am able to get a single calculation using the Dynamic Formula macro, as in the screenshot below.
How would I modify the Dynamic Formula Macro accomplish getting multiple calculations for one V-A?
This is a sample of what a list of calculations for one V-A combination would be:
Solved! Go to Solution.
@danilang Sorry I took so long to accept your solution.