Formula to bring in the header

  • Thread starter Thread starter peterh
  • Start date Start date
P

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.
 
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))
 
Back
Top