I am trying to make a simple spreadsheet that compares the cost of auto parts from several companies and returns the name of the company that has the lowest price in a specific cell. I cannot find a function that seems to do this, any help would be great.
iPhone 6 Plus, iOS 8.3
Hi jh,
Formula in Footer Cell of Table 1 (and Fill Right)
=MIN(B)
Formula in B1 of Table 2 (and Fill Right)
=INDEX(Table 1::$A,MATCH(Table 1::B8,Table 1::B,0))
When there is a tie, it returns the first company that matches MIN.
You could add another Footer Row to count multiple minimums
=COUNTIF(B,B8) and Fill Right
Regards,
Ian.
Hi jh,
Formula in Footer Cell of Table 1 (and Fill Right)
=MIN(B)
Formula in B1 of Table 2 (and Fill Right)
=INDEX(Table 1::$A,MATCH(Table 1::B8,Table 1::B,0))
When there is a tie, it returns the first company that matches MIN.
You could add another Footer Row to count multiple minimums
=COUNTIF(B,B8) and Fill Right
Regards,
Ian.
Thank you Yellowbox that did it. It took me a while to actually get back to this but it did work. Thank you for the help.
How can I make a simple price comparison for autoparts and have the company with the lowest priced parts returned in a cell in a numbers spreadsheet?
