Let's say the real data in Sheet1
On Sheet2, row 5 , start with A5, enter your code S, UL, US
In A6 enter =Sheet1!H6, in B6 =Sheet1!M6, in C6 =Sheet1!R6
Copy A6:C6 down the sheet as far as needed
On Sheet1 (real data sheet) in the cell where you want the code for 6, enter
=INDEX(Sheet2!$A$5:$C$5,1,MATCH(MIN(Sheet2!A6:C6), Sheet2!A6:C6,0))
Copy this down the column as far as needed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"scoobydoo2006"
wrote in message
news:scoobydoo2006.29coqn_1150218603.7596@excelfor um-nospam.com...

Actually I can use a helper sheet and make the column sequential (A-C).
The Min formula you supplied does identify the least cost item. I now
need to convert that to the given code for that vendors price column
(A-C). Costs will not exceed $1000.00. So if you can help with the code
conversion I think we have it. Column A if selected as the Min in Column
D would convert to "S" in col D instead of the actual cost. Col B
converts to "UL" and Col C to "US".

Thank You


--
scoobydoo2006
------------------------------------------------------------------------
scoobydoo2006's Profile:
http://www.excelforum.com/member.php...o&userid=35372
View this thread: http://www.excelforum.com/showthread...hreadid=551446