One way would be to use a table
col a col b
a 123456789
b 23456789
and use VLOOKUP formulas
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"A. Mart" <A. wrote in message
...
I am trying to put together a spread sheet that will allow me to type a
specific letter and a 9 digit code will appear once I enter the letter.