make a letter in a cell automatically equal a dollar amount

K

kimzim

need to know the formula to have a certain group of cells set up so that when
a specific letter is entered, it will automatically enter a dollar amount
 
D

DaveB

Set up a lookup table that will match the numeric dollar amount to the
corresponding letter, assume this will occur in columns A and B like so, and
starting in row 1:

Column A Column B
Row1 A $100
Row2 B $200
Row3 C $300
... ...

Now, assume you enter all of your letters column D starting on row 1 (so
first value is in D1), enter this function in E1 to output the corresponding
numeric dollar amount:

=VLOOKUP(D1,$A$1:$B$1000,2,0)

Does that help?
 
Top