I'm trying to do a left lookup, as in one that will return a value on the column to the left of my lookup. I understand that it has to use and index and match function, however I'm not so sure how this will work as I've never really used them before.

I am trying to rank probabilities in ascending order. So if I wanted to get the 2nd highest probability from 4 possibilities in the range B23-B26, it would be 

=LARGE(B23:B26,2)
Now i just need the lookup to return the cell to the left of this (i.e. from column A). I have tried 

=INDEX(A23:B26,LARGE(B23:B26,1),A23:A26)
but that does not seem to work. Please help!