You need to create a table with all codes and their numbers
MSP 510
PDX 710
and so on
assume that table would be in A2:B26
and that you type the code into H2, now you can use (let's say the formula
is in I2)
=VLOOKUP(H2,A2:B26,2,0)
now when you type MSP in H2 I2 would return 510
Regards,
Peo Sjoblom
"Brooks W." wrote:
I am trying to see if there is a way to change text entered into a cell into
a number based on the text entered. As an example, an airport code of MSP
would need to be changed to a store number 510. Is there a way to do this in
Excel 2000? There are about 25 codes that could be entered and of course 25
numbers.
Any suggestions would be appreciated.
--
Brooks W.
|