Can you do a lookup from right to left?

[tbrum14]

To make this easy,lets say I have 2 columns A & B. Say column A is a name, and column B is a number. I want to write a formula that will give me the name associated with the smallest # in column B. Any thoughts?

 

[nbrcrunch]

index and match combination will do that for you.

http://www.mrexcel.com/articles/excel-vlookup-index-match.php

 

[texasalynn]

Welcome to MrExcel board...

The index/match can do a lookup to the left. Post a small sample of your data. There are a few ways to post samples.
http://www.puremis.net/excel/downloads.shtml
http://www.excel-jeanie-html.de/index.php?f=1

 

[lenze]

Hi and welcome to the board!! Try something like this

=INDEX(A1:A5,MATCH(MIN(B1:B5),B1:B5,0),1)

Note this will return the first instance of the MIN value if you have duplicate values

lenze

 

[tbrum14]

Thanks, I got it to work. I used an if stmt to make sure it only gave me a name if the lowest # was unique!