have excel return the location of the value found by a MIN formula

Experts/Gurus,

Hello, this is my first post, I will try and provide all the info necessary for assistance.

I have a spreadsheet that contains numerous columns of part suppliers, each supplier has 3 columns, Supplier 1 has columns H, I, J, Supplier 2 has K, L, M, etc.

H,K= bid price
I,L=quantity
J,M=cost to purchase quantity bid

I also have column F
F = MIN formula that scans all the 1st columns from all the suppliers and returns the MIN value which would be the bid price, in example above column H.

I have a blank column G
I want G to return the location of the value found in column F. so I can reconcile min bid price with the respective supplier.
I have tried combinations of "=ADDRESS" and "=MATCH" formulas but run into an issue as the columns being checked are not contiguous.

I would greatly appreciate it if anyone could offer assistance.

Thank you,
Dave

dstephens80,

Welcome to the forum!
Assuming there are headers in row 1, and you want to return the appropriate header (so if the match in F was for K, K's header would be something like "Supplier 2 Bid Price" and that is what the output of column G should be), this formula should work for you. Put it in cell G2 and copy down:
=INDEX($H$1:$M$1,,MATCH(1,INDEX((MOD(COLUMN(H2:M2),3)=2)*(H2:M2=F2),),0))