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