Forum Discussion
Mr_Raj_C
Jan 25, 2025Brass Contributor
Help with building a modelling tool
Dear Excel Community,
Hope you are all keeping well ?
I'm currently seeking some help in finishing off a modelling tool want to build in Excel (see attached).
Essentially, the tool is to help inform material values based on 3 variables,
Total Tonnage - manual entry
Composition - From a selection
Commodities - From a selection
So in the attached workbook, the user will input the tonnage value on sheet "Model" in cell B2.
They then select the Commodity values to use. This will be a choice of "low", "Average" or "High". Based on the choice made, i would like Excel to populate cells D10:D27 with the corresponding values from sheet "Commodities".
The user then selects the Composition value in cell B6. As above, depending on the selection, i would like Excel to populate cells B10:B27 with the corresponding values in sheet "Composition".
I would be really grateful if someone could give me some ideas or a solution on the easiest way to make this work.
As always, thanking you in advance.
Kind regards
Raj
SergeiBaklanThank you so much. This is exactly what i was looking for.
Just one question though, the formula's in Column C don't seem to be working in the current state but if i reverse the formula, it works. Would appreciate your thoughts as to why that could be ?
Thanks
Raj
- Mr_Raj_CBrass Contributor
SergeiBaklanThank you so much. This is exactly what i was looking for.
Just one question though, the formula's in Column C don't seem to be working in the current state but if i reverse the formula, it works. Would appreciate your thoughts as to why that could be ?
Thanks
RajMr_Raj_C , I didn't touch formula in column C. Perhaps you meant
=$B$2*(1-B10)
Not sure what is the business logic behind.