| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting corresponding test value to a MIN function
I have a sheet that looks something like this...
Supplier Price Low Price Supplier Low Price Jimmy's Widgets 10 7 Widget World 45 Widget Discount 7 Widget's R Us 35565 I am able to get "7" to come up as my low price with this function... =MIN(B2:B5) but I want the name of the corresponding supplier to appear under "Low Price Supplier". I have tried various combinations of IF, MATCH, etc. with no success. Help Please!! Thanks, Chris the excel peon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| struggling with if logical test function | Excel Worksheet Functions | |||
| Can someone test this IF function for me, I'm not sure that it works. | Excel Worksheet Functions | |||
| IF Function to test formula in a cell | Excel Worksheet Functions | |||
| Getting corresponding test value to a MIN function | Excel Worksheet Functions | |||
| Function IF / test / Picture result | Excel Worksheet Functions | |||
Threaded Mode
