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