Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing Cell Data
I created two spreadsheets. The first spreadsheet is called Agent List and
has two columns. The first column has the names of all agents, the second is their phone extension. In the second spreadsheet, I want to enter a phone extension in the first column and have it automatically replace it with the name of the agent by looking it up in the first spreadsheet. I created and used these spreadsheets for the past six years but I dont remember how I set it up. I received a new PC and none of my formulas or macros seem to work. Can anyone tell me how I did this? Just as a reference, I had been using Office 2003 on my old PC, and I am still using 2003. -- Mary Ann |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing Cell Data
If you haven't changed the macro security setting (tools|macro|security), then
no macros will run. Excel installs with security set to high (IIRC). And maybe you used a separate column that returned the name based on the phone number: =index(sheet2!a:a,match(a1,sheet2!b:b,0)) Debra Dalgleish has some notes: http://www.contextures.com/xlFunctions03.html (for =index(match())) Mary Ann wrote: I created two spreadsheets. The first spreadsheet is called Agent List and has two columns. The first column has the names of all agents, the second is their phone extension. In the second spreadsheet, I want to enter a phone extension in the first column and have it automatically replace it with the name of the agent by looking it up in the first spreadsheet. I created and used these spreadsheets for the past six years but I dont remember how I set it up. I received a new PC and none of my formulas or macros seem to work. Can anyone tell me how I did this? Just as a reference, I had been using Office 2003 on my old PC, and I am still using 2003. -- Mary Ann -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Enter data and Function in same cell | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Cell data format | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions |