tparmbru22
New Member
- Joined
- Sep 7, 2017
- Messages
- 15
I need help creating a formula that will return the vendor name based on their cost. I need the formula to return the lowest 3 vendors. The formula will be used in COLUMNS B,C,D.
I've tried using the INDEX,MATCH function combo but I'm not having any luck. Below is an example of the data I'm using.
Any help would be appreciated.
<tbody>
</tbody>
I've tried using the INDEX,MATCH function combo but I'm not having any luck. Below is an example of the data I'm using.
Any help would be appreciated.
A | B | C | D | E | F | G | H | I | |
1 | Destination | 1st Low Bid | 2nd Low Bid | 3rd Low Bid | Vendor1 | Vendor2 | Vendor3 | Vendor4 | Vendor5 |
2 | Destination1 | Vendor4 | Vendor2 | Vendor3 | 25 | 15 | 20 | 10 | 50 |
3 | Destination2 | Vendor1 | Vendor2 | Vendor3 | 20 | 30 | 30 | 40 | |
4 | Destination3 | Vendor2 | Vendor3 | Vendor1 | 30 | 25 | 25 | 40 | 45 |
5 | Destination4 | Vendor1 | Vendor4 | Vendor3 | 15 | 30 | 20 | 40 | |
6 | Destination5 | Vendor1 | Vendor3 | Vendor2 | 10 | 20 | 15 | 30 | |
7 | Destination6 | Vendor2 | Vendor1 | Vendor5 | 45 | 40 | 60 | 60 | 45 |
8 | Destination7 | Vendor1 | Vendor2 | Vendor5 | 50 | 55 | 70 | 60 | |
9 | Destination8 | Vendor4 | Vendor1 | Vendor5 | 35 | 60 | 50 | 25 | 45 |
10 | Destination9 | Vendor3 | Vendor1 | Vendor4 | 20 | 10 | 30 | 40 | |
11 | Destination10 | Vendor3 | Vendor5 | Vendor2 | 45 | 30 | 35 |
<tbody>
</tbody>