Prev: text change
Next: Paste Special function and Hyperlinks
From: A. Mart A. on 19 May 2010 11:26
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.
From: Don Guillett on 19 May 2010 11:33
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
dguillett(a)gmail.com
"A. Mart" <A. Mart(a)discussions.microsoft.com> wrote in message
news:4BDD4E06-E481-4456-958D-DD1C8B311570(a)microsoft.com...
>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.

 | 
Pages: 1
Prev: text change
Next: Paste Special function and Hyperlinks