Trying to pick a result from a table

Hi,

Basically I have been doing the modelling thing that I like to do again, and have tried to do something different with one of my sims, but can't quite get the results from the sim the way I would like to get them (if that makes sense - I believe the @risk package has an option to do this, but I was trying to make a workaround).

In short in the attached which is just 5 results (the full workbook has a couple of data tables and if/or's etc., I've stripped all of the workings out for ease) from one of the sims in the workbook, it shows how far each of the 8 teams listed will get.

Basically in the top table (results which I have highlighted green), I am just trying to return the values in column J (highlighted yellow) which I have just inputted in the attached. Basically I then intend to use them as a results cell for a data table (for each team). As you can see from looking at the 5 sets of results in the case of St.Louis Blues it would return, STANLEY, DIVISIONAL, SEMI, WIN, WIN.

I wasn't sure quite how to do this. I thought I could possibly do this with an index and a match (but wasn't quite sure how to express the function - if that makes sense).

Any pointers or nudges in the right direction would be appreciated.

Thanks in advance,

Results_Test.xlsx

Originally Posted by popipipo

=INDEX(E11:I11,0,MATCH(I11,E11:I11,0)-1)

Try this one

Almost - it works except for when something is in the "win" column (which is I). I'm happy I figured out which functions I needed to use (but a bit embaressed that I didn't know what to do with them).

Spot on. Thank you for your help, and now I will try and work the formula out for my own benefit.