Lookup within an Array Based on the Minimum Value of One Column

[YeshyTiger]

Hello,

So I have a problem that I'd rather solve in a formula than write VBA to force what I want...

I have an array where I have "Make" and "Model" of certain products with the "List Price"

I wrote the formula to find MINimum "List Price" but I need to be able to see which "Make" and "Model" that corresponds to.

Someone must have figured this out already but I can't seem to find that. I swear I've searched for this in all I know how to ask but all the results give me "how to find a min"... If you can point me in the right direction I'll be ecstatic!

Jesse

 

[barry houdini]

Try this to get the Make

=INDEX(Make,MATCH(Min(Price),Price,0))

and similar for Model

 

[YeshyTiger]

Worked like a charm. Thank you kind sir!

Frustrating when it's a simple solution that felt so complicated