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

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