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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel --> Word 4
Insert name and adress from a list in a word document 1
Mail Merge Directory Conditional Page Break 0
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Keep First Letters, with exceptions 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Improving Macro That Keeps First Letter 0
Delete all data after a symbol in a field 0

Top