Look up
Posted by Ken on December 14, 2001 6:42 AM
Is there a way that when I enter a number in a cell it will pull the name associated with that number in another cell.
Ken
Posted by Dan on December 14, 2001 6:48 AM
You can use the VLOOKUP function to accomplish that. Example: If you have 1,2,3,4,5 in Cells A1:A5 and names in cells B1:B5. You can place a number in C1 and have D1 pull up the associated name with the formula:
=VLOOKUP(C1,A1:B5,2,0)
For an explanation of how this works, look up VLOOKUP in Excel Help.
Posted by Aladin Akyurek on December 14, 2001 6:51 AM
Ken --
You need a 2-column list/table of numbers along with associated names like
1 ken
2 aladin
3 nicole
etc.
Lets say that you set up such a list in worksheet 2. Select all of the cells of this list, go to the Name Box on the Formula Bar, and type a name, e.g., NAMES.
Now you can retrieve the name associated with a number with
=VLOOKUP(A1,NAMES,2,0)
where A1 houses the input number.
Aladin
==========
