Refer to the excel sheet attached, I try to return a value in the 'Master tab' based on 2 models/scenario if the conditions met i.e. match the category, the rating and the entity.
However it did not succeed.
The condition to be met for both model are:
Model 1: IF column B3:B437 & C3:C437 & D3:D437 & F3:F437 in MASTER Tab are matched, Column I3:I437 in MASTER Tab will return value of E3 in MASTER TAB x (I30*C3:C6 in MODEL 1 Tab + I21:I29*D3:D6 in MODEL 1 Tab + D10:D13*E3:E6 in MODEL 1 Tab
Model 2: IF column B3:B437 & C3:C437 & D3:D437 & F3:F437 in MASTER Tab are matched, Column I3:I437 in MASTER Tab will return value of E3 in MASTER TAB x (I29*C3:C6 in MODEL 2 Tab + D10:D13*D3:D6 in MODEL 2 Tab
In the 'Summary Tab' I want to return the total cost by Entity to see the differences between budget and actual payout for the 2 model.
What will be the best way to ensure formula used can captured massive data.
Hope someone can assist and guide me.
Good day, You mention that if coulumns A, B, C D are matcehd. To what? The column A contains a unique ID so what do you want to match?
Maybe I am not reading your explanation correctly but ... I'm lost with what you are asking
Hello Ahmad,
What is the expected results? You do get values in return from your formulas, but you write you did not succeed.
Br,
Anders
