Excel Code

A

A. Mart

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.
 
D

Don Guillett

One way would be to use a table
col a col b
a 123456789
b 23456789
and use VLOOKUP formulas
 
Top