Hello all,

If this is not the correct forum - please re-direct me.

I have two Excel files. One file contains information on roughly 10,000
people, including name, address, phone number, and a person id, the person id
being the unique identifier for each person. In this file the phone number
field contains a number (NOT THE ACTUAL PHONE NUMBER) that is like a pointer
or place-holder for the actual phone number.

To find what that person's phone number is I have to "link out" to the other
excel file, look up that place-holder number (in field #1) , and get the
phone number( in field #2), respectively. I would like to replace that
"place-holder" number with the actual phone number that belongs to that
person in that first file. How can I do this?

Will provide more info, if need be,

Thank you,
Bill