Have you used VLOOKUP before? I would insert a column into our sheet and use
VLOOKUP to find the proper phone number from the other sheet. Then i would
copy and paste special....values over top of the vlookup formula column.
this should give you a column with the phone numbers, you could then delete
the column with the indicator number from your main sheet if you wish.

(Of course always make a back up of your files before doing major data
manipulation.)

"Bkana" wrote:


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