Large spreadsheet with supplier quoted prices in columns F-Z (could increase)
with supplier names as headers in row one. About 300 rows of data entered.
Am using the following in column AA to capture the low bid while skipping
the blanks: {=MIN(IF(F2:Z20,F2:Z2))}
Am using the following in column AB to attempt to list the name of the low
bidder, drawing the name from row one header:
=INDEX($F$1:$Z$1,1,MATCH(AA2,F2:Z2))

Problem is that it returns a text answer, but not always the correct one.