Suggestions for Creating a Data Point on a Version, Based on alternate Version
Our model has three key types of Versions - Actuals, Baselines, and Custom Scenarios. I have multiple Baseline Versions and many more Custom Scenarios - the end-user will be able to select which two they would like to use. My thought is a drop-down List of the Versions for "Baseline" - all other modules on the dashboard will be the selected Custom Scenarios.
I've developed two separate modules to capture the (A) Baseline Price % and (B) Custom Scenario Price %. I want to have a third module compare the Custom % / Baseline % to determine the mark-up/down percentage, then apply that factor to the Baseline % to generate an "Adjusted Baseline" which will feed the revenue module.
I need assistance with the "Select Baseline Version". Is there a way in my third module to have a SUM/LOOKUP/SELECT formula that will retrieve the month's Baseline Price for the selected scenario? The rest of the third module is controlled by Version selected for the specific module.