# How to populate Name based on lowest bid?

#### xlmaniac

##### Well-known Member
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

 * A B C D E F G H I 1 * 1st Quotation 2nd Quotation 3rd Quotation Final 2 Particulars Party Name Quotation Party Name Quotation Party Name Quotation Party Name Quotation 3 Asset1 A 100 D 150 G 170 A 100 4 Asset2 B 200 E 100 H 180 E 100 5 Asset3 C 300 F 150 I 210 F 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>

 Cell Formula 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

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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)

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

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

You're welcome.

Replies
0
Views
1K
Replies
3
Views
153
Replies
2
Views
638
Replies
5
Views
756
Replies
6
Views
601

1,214,720
Messages
6,121,121
Members
449,013
Latest member
JerrExcel

### 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.

### Which adblocker are you using?

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

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