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.

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.
