need help with formula

[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

 

[Dave R.]

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

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.

 

[Guest]

It appears that you are an Excel God..

Thanks Dave R.

 

[Aladin Akyurek]

See my contrib in:

http://tinyurl.com/22f83

for a formula system.

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.