Getting Header of minimum value followed by reference number

[Mohsin110]

I want to get the Header of the Min. Value of the short listed reference numbers only from a table. Is there any way to get it using vlookup or something.
I can get the header of minimum value using this formula =XLOOKUP(MIN(Freight2024!$P2:$AC2),Freight2024!$P2:$AC2,Freight2024!$P$1:$AC$1) but it doesn't follow the reference number.

 

[p45cal]

Let's have a workbook with what's in your picture, so that we can experiment…

Do any of the values in column A (Ref) repeat themselves in that column?

 

[Peter Bartholomew]

This is 365 only (as are all my solutions)

= MAP(requiredRef, LAMBDA(req,
    LET(
      row, XLOOKUP(req, ref, data),
      fwd, TAKE(SORTBY(header, row),,1),
      fwd
    )
  ))