Help with Excel

[nick_taira1]

With my job I need to type what seems like random numbers such as "3H23563" and I want to be able to write all my random numbers and have them automatically convert to a dollar figure. For example: 3H23563 would equal $15.25 in a different column when I type that random number into excel.
--3H23563 would be the billing code and $15.25 would be the cost of the billing-- Any help would be GREAT!

 

[sterion66]

Would that random code always equate to the same billing cost?

E.g.

3H3477 would always cost £15?

 

[nick_taira1]

Yes the random number would always equal the same price

 

[MrVillareal]

one way like this, just simple illustration or if you can post sample much better,

Excel 2010
	F	G	H	I	J
7	Code	Cost		Code	Cost
8	ax1	100		ax3	300
9	ax2	200
10	ax3	300
11	ax4	400
12	ax5	500
13	ax6	600
14	ax7	700
Sheet2

Cell Formulas
Range	Formula
J8	=VLOOKUP(I8,$F$8:$G$14,2,FALSE)

 

[nick_taira1]

I will try to draw it out and make sense of this project I'm trying to tackle. Pretend that this is in Excel 2007:

EXAMPLE​

Code ID Quantity Price TOTAL
A B C D E

1 H327 09 3 $7.25 $21.75


How would I get Excel to recognize item A1 (H327) having a cost of $7.25 per unit and placing it in section D1? Any info would be much appreciated again. Thank you!

 

[nick_taira1]

Any suggestions out there? Thanks

 

[Mohammad Basem]

MrVillareal has already provided you with the solution.

Just enter the LOOKUP formula in column D and change the references to your lookup table and the code in column A.

Do you have a lookup table that shows all codes along with their cost values, as in MrVillareal’s example?

 

[nick_taira1]

I guess I need to make a lookup table. And I don't know how to go about that. Any help?

 

[Mohammad Basem]

<P>If you have the complete list of codes along with their costs in Excel sheet, then this is the look-up table. Otherwise, enter it.</P>

 

[nick_taira1]

Will try. Thanks for your help. Never had to do anything like this before.