Log In
Register
Home
June 16, 2015
Offline
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.
Trusted Members
October 17, 2018
Offline
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
1 Guest(s)
