Cell F10 is a choice-box: 'Best', 'Base', 'Worst' case. I'm trying to change Revenue growth (F11) based on that selection.
How do I use match as the row argument of the OFFSET function in cell F11 to change revenue growth based on the scenario selected in cell F10? I'm using cell D5 a starting/reference point in my formula.
My incorrect attempted solution: OFFSET(D5, MATCH($F$10, $C$14:$C$16,0),0)