Excel Functions Help

[links_now]

Say I wanted to have a column that if I typed SR it would come up with a
price of $4.00 if I typed L12 it would come up with a price of $3.75 and so
on. Is this possible. Thank you

Rob

 

[Don Guillett]

Have a look in the help index for VLOOKUP

 

[T. Valko]

See this:

http://contextures.com/xlFunctions02.html