Either through using AutoCorrect by building a list or by VBA event code.

Would be much easier to use a helper column and a VLOOKUP formula.

Use Data Validation for in-cell drop-down for selecting a number and VLOOKUP
for the filling-in part.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Sun, 18 Feb 2007 10:53:02 -0800, FC wrote:

I got a list of names related to 4 digit number that I memorized. It is
possible to write a formula or anyway that if I write the number in a cell (
ex.123 in A2) instead of the number, the name Luis will appear in that same
cell ( A2). Tx