Converting text in a drop down list to a specific # in another cell

If on another sheet, you have the company codes (i.e. sheet2!A1:B15) like so
Excel 2010

Row\Col	A	B
1	abc	1
2	def	2
3	xyz	3

Sheet: Sheet2

Then in the cell where you want the code to show up

with dropdown in A1
=IFERROR(VLOOKUP(A1, sheet2!$A$1:$B$15,2, FALSE),"")
Is that what you are asking for?

=IFERROR(INDEX($J$1:$J$10,MATCH(A1,$A$1:$A$10,0)),"")

Please refer the attached sheet.

Actually if your company values are numeric from 1 to 15, then you'd just need MATCH
=MATCH(A2, Sheet2!$A$1:$A$15,0)

Or if you want to get fancy, you can use a forms Combo box from the Developer tab for your dropdown box and set your output cell to E1

Neither of thos really accomplished what I am looking for. I fear the fault is mine. I have attached a version of my actual form. You will see the rows with (color shaded) the drop down list (rows 14, 28,43,57 to be exact). To the right of the is shows what I would like it to look like. The the immediate right of that you will see a colored in area numbered from 1-30 (this is my end-game idea to get to)

This colored in are to the far right represents an actual tag/receipt given out once they leave the site showing their entry fee. The color of the tag (pink,Blue or Golden-Rod (not shown)) coordinates with the actual tags we hand out (Pink is for a $5 tag, Golden-Rod for a $20 tag and Blue for a $33 tag.

So, in the end; what I would like to do is make selections on the drop down lists and they show up in the colored are with their totals filling in the cells next to the appropriate House number (1-30) and the color of the area matching the price of the actual tag we hand out (Just as cells B18, B33, B47 and B64 do now)

Thanks again guys, your the best

Okay, so where do the 15 and 2 come from?? Rigo's is the 23rd name in your list.