Hi, i just want to get the header of the minimum values followed by the short listed reference numbers from a table in google sheets, but i can get the minimum values successfully using the following function,
=XLOOKUP(SMALL(Freight2024!$P2:$AC2,1),Freight2024!$P2:$AC2,Freight2024!$P$1:$AC$1)
but it's not followed by reference numbers in column a, is there any way to vlookup or something to get the header of the minimum value of the reference numbers only.
Hope I've successfully explained.
=XLOOKUP(SMALL(Freight2024!$P2:$AC2,1),Freight2024!$P2:$AC2,Freight2024!$P$1:$AC$1)
but it's not followed by reference numbers in column a, is there any way to vlookup or something to get the header of the minimum value of the reference numbers only.
Hope I've successfully explained.