Formula to bring in the header

[peterh]

I have a worksheet & need to bring into cell M4 the cheapest supplier, 9 of
columns D to L in row 4, we have a formula that brings in the cheapest price
into column N from row 19 down.

 

[Jacob Skaria]

I am not sure i understood your question correctly. The below formula finds
the cheapest price in range D19:L19 and then returns the matching header from
Row4 range D4:L4.

=INDEX(D4:L4,MATCH(MIN(D19:L19),D19:L19,0))