Replacing Cell Data

[Guest]

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 don’t
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.

 

[Dave Peterson]

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()))