Hi,
On the attached spreadsheet I have cells where I need to apply an index and match formula but I always struggle how to do this.
Based on what I think I need, the formula must do the following the following:
The formula will go in F26, F27 and F28
I think the index is C6:L9
Then I need it to match with cells C26,C27,C28 and with J13 (this displays best/expect/worst)
so for example if a user selects best in cell F26 this should display "86" (the value in cell J7)
I have attached a spreadsheet example
Can anyone help?
Bookmarks