=index(g19:g23,match(min(h19:h23),h19:h23,0))

Debra Dalgleish has some nice instructions for =vlookup() and =index/match at:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

Ken wrote:

I have =vlookup(h25,g19:h23,2,false) which returns a number when I type a
name. How can I reverse this? Basically, I am using MIN in a formula in
column B and when I get the result of the MIN formula I would like it to
return the corresponding name from column A. I am using cells B1, B3,
B5..... thru B15 and A1, A3, A5.... thru A15. Column B MIN gives me a number
00.00 and I need the name in column A to be the result of the vlookup.
Incidentally the vlookup I mentioned at the beginning came from this group.
I've not progress enough to do this on my own as of yet. Obviously.
Thanks,
Ken

--

Dave Peterson