Thread: Index/Match Formula required

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?

Not to worry I managed it,

=INDEX($J$7:$L$9,MATCH(C27,$C$7:$C$9,0),MATCH($J$13,$J$6:$L$6,0))

Index and match is finally going in my brain