How to populate Name based on lowest bid?

xlmaniac

Well-known Member
Joined
Jul 2, 2009
Messages
513
Office Version
  1. 2010
Platform
  1. Windows
Dear All,
I do have a small Data Set as follows.
I would like to populate the name of the lowest bidder based on the lowest quote.
Could somebody help me with the formulae across H3:H5 pls?
Regards
Sheet1

*ABCDEFGHI
1*1st Quotation2nd Quotation3rd QuotationFinal
2ParticularsParty NameQuotationParty NameQuotationParty NameQuotationParty NameQuotation
3Asset1A100D150G170A100
4Asset2B200E100H180E100
5Asset3C300F150I210F 150

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 69px;"><col style="width: 76px;"><col style="width: 63px;"><col style="width: 76px;"><col style="width: 63px;"><col style="width: 76px;"><col style="width: 63px;"><col style="width: 76px;"><col style="width: 63px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas
CellFormula
I3=MIN(G3,E3,C3)
I4=MIN(G4,E4,C4)
I5=MIN(G5,E5,C5)

<tbody>
</tbody>

<tbody>
</tbody>


Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

bbott

Well-known Member
Joined
Feb 5, 2010
Messages
2,350
Try this in H3 and copy down.

=INDEX(B3:G3,1,MATCH(I3,B3:G3,0)-1)

or, if you don't want to use the reference to the MIN in column I:

=INDEX(B3:G3,1,MATCH(MIN(C3,E3,G3),B3:G3,0)-1)
 

xlmaniac

Well-known Member
Joined
Jul 2, 2009
Messages
513
Office Version
  1. 2010
Platform
  1. Windows
Thank you so much bbott for all your support...
Really appreciate the same..
You have saved hours of my working on this file..
Thanks again:):)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,215
Messages
5,836,053
Members
430,403
Latest member
RoToR

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top