Assigning a number to a name

A

Adel1216

Excel 2007 - I have multiple account numbers and each one belongs to one
person. I want to know if it's possible to do a setup so that I can type in
a name and when I hit enter, the number I assigned to that name shows up
instead of the name?
 
C

CLR

If yo want to type the name in one cell and have the number appear in the
next cell, then put the name in A1 and put this formula in B1,
=VLOOKUP(a1,D1:E10,2,false) and in D1:D10 put the names and in E1:E10 put
their numbers.

If you want it to all occur in one cell, it would take a change-event macro

Vaya con Dios,
Chuck, CABGx3
 

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

Assigning words to a number 1
Insert Name based on the account number 2
loopkup part of a name or number 2
auto populate a list 1
entering data into a premade form 3
Assigning values to a variable set 1
PivotTable Row Count 3
Format Text to number 3

Top