In a hurry ..but try
I tried the formula =INDEX($F$2:$AQ$1,1,MATCH(AR2,F2:AQ2)) where

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"perplexed" wrote in message
...
I tried the formula =INDEX($F$1:$AQ$1,1,MATCH(AR2,F2:AQ2)) whe
F is the first column of entered data
AQ is the last column of entered data
AR is the stored result of the MIN array
Row 1 is the supplier names (alternating with an extension column for each
entry)

The results are responding with header text, but from the wrong columns.

"perplexed" wrote:

The formula was a format example only. The data actually starts in
column F
with the part information to the left of that and supplier names as the
header text. I will try the suggested formula. Thanks.

"Bernard Liengme" wrote:

You need to use Match and Index but please tell us:
If the data is in 80 columns by 300 rows, why are you looking at only
10
rows.
Let us know the actual layout.
I suspect row 1 has supplier names
Is each subsequent row a lists of bids on a particular item (named in
column
A)?
=MIN(IF(B2:CB20,B2:CB2)) will give the minimum non-zero bid in row 2

I will show example with 6 suppliers (B1:G1)
Minimum {=MIN(IF(B25:G250,B25:G25))} in I2
Supplier =INDEX($B$1:$G$1,1,MATCH(I2,B2:G2))

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"perplexed" wrote in message
...
I am using the array formula {=MIN(IF(A1:A100,A1:A10))} to find the
minimum
bid from a supplier in a large (80 columns x 300 row) spreadsheet and
want
to
find the column header text (Supplier Name) for the minimum value.