Struggling with formula

[samilynn]

Hi, I am struggling to come up with the formula to show me the name of the lowest vendor for each SKU (as in the last column in the example below)
If there is a way to do this, can you give me some guidance please?

Thanks!
Samantha

SKU	VENDOR "A"	VENDOR "B"	VENDOR "C"	WHO IS LOWEST?
A123	$1.00	$1.25	$1.50	VENDOR "A"
A555	$10.00	$9.00	$9.50	VENDOR "B"
B456	$0.15	$0.17	$0.10	VENDOR "C"
B666	$6.21	$6.18	$6.99	VENDOR "B"

 

[Joe4]

Let's say that data is in the range A1:D5.
Then put this formula in cell E2 and copy down:

=INDEX(B$1:D$1,MATCH(MIN(B2:D2),B2:D2,0))

 

[samilynn]

Thank you, Joe, that works great!!!!
One more question, if I may: is it possible to do it if the three price columns are not next to each other? For example, if they are in Columns B, D, and G?
I guess I could move them next to each other if I have to, but I would love to know and learn if there is a formula to do it if they have other columns in between.

Thanks again so much!
Samantha

 

[Joe4]

Thank you, Joe, that works great!!!!
One more question, if I may: is it possible to do it if the three price columns are not next to each other? For example, if they are in Columns B, D, and G?
I guess I could move them next to each other if I have to, but I would love to know and learn if there is a formula to do it if they have other columns in between.

Thanks again so much!
Samantha

Not using that formula. That is going to make things much trickier. I personally do not know how to that without some really long complex formula or using VBA.
If you want to pursue that, I would recommend starting a new thread, as that is a different question.

 

[samilynn]

Thank you, Joe, your first formula will do!

Thanks again,

Samantha

 

[Joe4]

You are welcome.