Left Lookup

**clattenburg cake** · 06-28-2013, 12:23 PM

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

Please Login or Register  to view this content.

Now i just need the lookup to return the cell to the left of this (i.e. from column A). I have tried

Please Login or Register  to view this content.

but that does not seem to work. Please help!

**Jonmo1** · 06-28-2013, 12:26 PM

You almost had it..

=INDEX(A23:A26,MATCH(LARGE(B23:B26,1),B23:B26,0))

**ConneXionLost** · 06-28-2013, 12:27 PM

You are missing the MATCH function:

Please Login or Register  to view this content.

**XOR LX** · 06-28-2013, 12:28 PM

Hi,

Try: =INDEX(A23:B26,MATCH(LARGE(B23:B26,1),B23:B26,0),1)

Regards

**TMS** · 06-28-2013, 12:29 PM

=INDEX(A23:A26,MATCH(LARGE(B23:B26,1),B23:B26,0)

Regards, TMS

**clattenburg cake** · 06-28-2013, 12:37 PM

Thanks, you guys are legends.

**TMS** · 06-28-2013, 12:44 PM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.