Formula to return vendor names based on costs

[tparmbru22]

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.

	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>

 

[tparmbru22]

Check the formula which might now show COLUMN(C$1) and change it back to COLUMN(A$1).

WBD

That was the issue, I thought I looked for that but must has over looked it. Thanks again for all the help.