need help with formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

worksheet 1 has 4 products down the rows, the columns are headed by 5 vendors. The 5 vendors are bidding on each of the 4 products

worksheet 2 has the 4 products listed with the minimum bid in the next cell (min function). What I am looking for is how to associate the name of the lowest bidder in the cell next to the lowest bid

Thanks for your help
 
You can try;

=INDEX(Sheet1!$B$1:$F$1, MATCH(MIN(Sheet1!B2:F2),Sheet1!B2:F2,0))

but, I'm not clear how the cell with the MIN function is involved. Do you
want to return the company name when it's bid is equal to the min bid?

As the formula is now, it simply returns the lowest bidder when the company
names are in sheet1!b1:f1, the items are listed in sheet1!a2:a5, and the
bids are in sheet1!b2:f5

amiebarnes said:
worksheet 1 has 4 products down the rows, the columns are headed by 5
Click to expand...
vendors. The 5 vendors are bidding on each of the 4 products.
worksheet 2 has the 4 products listed with the minimum bid in the next
Click to expand...
cell (min function). What I am looking for is how to associate the name of
the lowest bidder in the cell next to the lowest bid.
 
See my contrib in:

http://tinyurl.com/22f83

for a formula system.

amiebarnes said:
worksheet 1 has 4 products down the rows, the columns are headed by 5
Click to expand...
vendors. The 5 vendors are bidding on each of the 4 products.
worksheet 2 has the 4 products listed with the minimum bid in the next
Click to expand...
cell (min function). What I am looking for is how to associate the name of
the lowest bidder in the cell next to the lowest bid.
 
Back
Top