Nested IF Funtction Help

[Longdayz]

I’m looking for help on a Nested IF function in excel.
Cells A2 thru A6 have a name
Cells B2 thru B6 have a dollar amount
I need to cell B9 to display the name in the cell that is associated with the lowest dollar value.

Can someone help me with the formula? Thanks

[#2]

@Longdayz  here is a formula that does what you want :

=INDEX(A2:A6,MATCH(MIN(B2:B6),B2:B6,0))

[#3]

your a great human, thank you.@mtarler