Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning a number to a name
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning a number to a name
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 "Adel1216" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning a word to a number | Excel Worksheet Functions | |||
Assigning Row Number to TextBox | Excel Discussion (Misc queries) | |||
Assigning words to a number | Excel Discussion (Misc queries) | |||
Help assigning a number to a word | Excel Discussion (Misc queries) | |||
Assigning a number value to a letter? | Excel Discussion (Misc queries) |