Nested IF Funtction Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1459875%22%20slang%3D%22en-US%22%3ENested%20IF%20Funtction%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459875%22%20slang%3D%22en-US%22%3E%3CP%3EI%E2%80%99m%20looking%20for%20help%20on%20a%20Nested%20IF%20function%20in%20excel.%3CBR%20%2F%3ECells%20A2%20thru%20A6%20have%20a%20name%3CBR%20%2F%3ECells%20B2%20thru%20B6%20have%20a%20dollar%20amount%3CBR%20%2F%3EI%20need%20to%20cell%20B9%20to%20display%20the%20name%20in%20the%20cell%20that%20is%20associated%20with%20the%20lowest%20dollar%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20with%20the%20formula%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1459875%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1459905%22%20slang%3D%22en-US%22%3ERe%3A%20Nested%20IF%20Funtction%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698076%22%20target%3D%22_blank%22%3E%40Longdayz%3C%2FA%3E%26nbsp%3B%20here%20is%20a%20formula%20that%20does%20what%20you%20want%20%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DINDEX(A2%3AA6%2CMATCH(MIN(B2%3AB6)%2CB2%3AB6%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1459917%22%20slang%3D%22en-US%22%3ERe%3A%20Nested%20IF%20Funtction%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459917%22%20slang%3D%22en-US%22%3E%3CP%3Eyour%20a%20great%20human%2C%20thank%20you.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Replies
Highlighted

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

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

 

Highlighted

your a great human, thank you.@mtarler