How to find Minimum Value between Several Columns and return Corresponding Company Name??

[kymikee]

I have a spreadsheet that contains the following:
I am checking prices between 5 different vendors:
Columns D, G, J, M and P contains the Vendors Part Numbers
Columns E, H, K, N and Q contains the Vendors Prices
Columns F, I, L O and R contain the Vendors initials

I am trying to set up a formula to find the Minimum Price on each Row (I have 31 Rows) and the return the Vendors Initials so I can know which Vendor has the lowest price on each item. Can someone help me to come up with a formula that can do this??

 

[mse330]

Hey kymikee,

Assuming your data starts at row 2, you can place the below formula in column S

=INDEX(E2:R2,1,MATCH(MIN(Q2,N2,K2,H2,E2),E2:R2,0)+1)

 

[kymikee]

Thanks So Much mse330!! That worked GREAT!! Exactly what I needed

 

[mse330]

Glad to help & thanks for reporting back