Excel Functions Help
 

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

Excel Functions Help
 

Have a look in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

" wrote
in message ...
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

Excel Functions Help
 

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


" wrote
in message ...
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