Lookup help, multiple columns

[texasduckhunter]

I'm unsure what formula I need to return an adjacent value to the min value from a set of columns...

My excel knowledge is very limited

I have data in cells BC20 to CJ20 and down to BC136 and over to CJ136

I have numbers in every other column and text in between

example:
BC20 has pricing
BD20 has lead time
BE20 has pricing
BF20 has lead time
and so on

I have a formula in CK20 to pull min value, im sure this is probably not the easiest way but its all I know [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=MIN(BC20,BE20,BG20,BI20,BK20,BM20,BO20,BQ20,BS20,BU20,BW20,BY20,CA20,CC20,CE20,CG20,CI20)

In column CL i pull in the vendor information from the column titles
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=INDEX($BC$19:$CB$19,MATCH(CK20,BC20:CB20,))

Those seem to work great

But my issue is that i need the corresponding lead time to pull into CM from the Min value i have in CK

HELP PLEASE [/FONT]_{^{<strike>
</strike>}}[/FONT]

 

[texasduckhunter]

here is a picture of the data on how its put in, sometimes i will have multiple bids for the same row, but not always

Vendor 1	Notes	Vendor 2	Notes	Vendor 3	Notes	Vendor 4	Notes	Low Cost	Vendor	Notes
10.30	stock	11.00	2-3 wks			15	stock
12	stock
15	stock	44				33	4 wks
17	stock	33
12	stock
122	stock	232

<tbody>
</tbody>

 

[texasduckhunter]

Vendor 1	Notes	Vendor 2	Notes	Vendor 3	Notes	Vendor 4	Notes	Vendor 5	Notes	Vendor 6	Notes	Vendor 7	Notes	Low Cost	Vendor	Notes
$ -		$ 56.00												$ -	#N/A	$ -
		$ 108.00	20 wks											$ -	#N/A	#N/A
		#########	Stock											$ -	#N/A	#N/A
		$ 66.00												$ -	#N/A	#N/A
		$ 66.00												$ -	#N/A	#N/A
		$ 66.00												$ -	#N/A	#N/A
		$ 66.00												$ -	#N/A	#N/A
		$ 165.00												$ -	#N/A	#N/A
		#########	6 wks											$ -	#N/A	#N/A
														$ -	#N/A	#N/A
				$ 550.00								$ 468.00		$ -	#N/A	#N/A
				$ 695.00								$ 568.86		$ -	#N/A	#N/A
				$ 800.00								$ 502.78		$ -	#N/A	#N/A
				$ 1,800.00										$ -	#N/A	#N/A
				$ 3,500.00										$ -	#N/A	#N/A
				$ 220.00								$ 235.04		$ -	#N/A	#N/A
				$ 220.00								$ 201.47		$ -	#N/A	#N/A
				$ 775.00								$ 300.91		$ -	#N/A	#N/A
														$ -	#N/A	#N/A

<colgroup><col span="14"><col><col span="2"></colgroup><tbody>
</tbody>