software

I have a large table filled with data. Each row is a named place, each
column a named supplier - the data table corresponds to tenders. On the
right hand side of the completed table, I have a column which picks out the
lowest tender for each place (quot;Lowest Bidquot;). What I now want to do is create
another column on the right of the quot;Lowest Bidquot; column to pick up the
quot;Prefered Supplierquot;. I.E. the supplier named in the title row which provided
us with the lowest tender. I have tried this is in numerous different ways
without success. The table is too large for me to consider doing it
manually. Help would be very much appreciated.

Try:

=OFFSET($A$1,0,MATCH(N2,B2:M2,0))

Assumes Suppliers start in B1 and bid prices are in columns B to M

N2=quot;Lowest Bidquot;
B2:M2 contain bid prices

Put in O2 i.e. cell next to quot;Lowest Bidquot; and Copy down

HTH

quot;ExcelConfusedquot; wrote:

gt; I have a large table filled with data. Each row is a named place, each
gt; column a named supplier - the data table corresponds to tenders. On the
gt; right hand side of the completed table, I have a column which picks out the
gt; lowest tender for each place (quot;Lowest Bidquot;). What I now want to do is create
gt; another column on the right of the quot;Lowest Bidquot; column to pick up the
gt; quot;Prefered Supplierquot;. I.E. the supplier named in the title row which provided
gt; us with the lowest tender. I have tried this is in numerous different ways
gt; without success. The table is too large for me to consider doing it
gt; manually. Help would be very much appreciated.