Need to add certain phone numbers in one column to a column in another file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

epenfold@blucom.ca - 20 Nov 2006 22:57 GMT

I have a spreadsheet with basic contact info including address and name
but no phone numbers. And I have another spreadsheet with just name
(same names as other spreadsheet) and phone number as column headers. I
need to add the phone numbers from one spreadsheet into the spreadsheet
with the names and addresses.

The tricky part is that I have a few hundred extra rows of names in the
spreadsheet with phone numbers only that I don't need and that aren't
in the other spreadsheet. So, I somehow need to insert the phone
numbers beside the appropriate names in the spreadsheet with names and
addresses only.

Any suggestions would be appreciated :) Thanks!

Emily

Reply to this Message

JE McGimpsey - 21 Nov 2006 02:09 GMT

> The tricky part is that I have a few hundred extra rows of names in the
> spreadsheet with phone numbers only that I don't need and that aren't
> in the other spreadsheet. So, I somehow need to insert the phone
> numbers beside the appropriate names in the spreadsheet with names and
> addresses only.

one way:

I'll assume that when you write "spreadsheet" you mean workbook, or
file, rather than a worksheet within a workbook.

Assume that the workbook with the phone numbers is named
"Workboook2.xls" with the data on worksheet "Sheet1", columns A & B.

Assume further that your address workbook has the names in column A of
the desired worksheet, and that the worksheet has column labels (Name,
Address, City...Phone...) in row 1. In the Phone column, row 2 enter:

=VLOOKUP(A2,'[Workbook2.xls]Sheet1'!A:B, 2, FALSE)

and copy down as far as required.

Now select the Phone column. Copy it. Choose Edit/Paste Special,
selecting the Values radio button in the dialog. Click OK.

Reply to this Message

Mac Forum / Applications / Excel / November 2006

Need to add certain phone numbers in one column to a column in another file