Ok - this is almost what I need. Except that for each contact name in the
one sheet, I need to have the origin of the contact displayed from the other
sheet. For instance, I have John Doe, 1234 What Street, What City, etc. in
sheet 2. I need to find the same John Doe in sheet 1 and have whatever is in
the "Origin" column of sheet1 displayed in the "Origin" Column of sheet 2.

"Bernard Liengme" wrote:

Look at VLOOKUP - this will link the two files. Come back if you have
questions; we can show you how to use Paste Special to break the link
between the two files
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Angela" wrote in message
...
I have 2 workbooks. The first workbook is a compilation of approximately
15,000 contacts. The second workbook is a copy of the first. Someone
eliminated a very important column in the second workbook. This column
contained the employee name that the contact originated from. I can not
just
go back and paste the original column in to the second workbook, because
there have been multiple revisions, deletions and additions to the second
work book.

I need a way to match each name in the second workbook to their name in
the
original workbook so that I can capture the origin for that contact name
which is only contained in the first workbook. Any idea how I can do
that?

Please explain why VLOOKUP would not work for you.
ttp://www.mvps.org/dmcritchie/excel/vlookup.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Angela" wrote in message ...
Ok - this is almost what I need. Except that for each contact name in the
one sheet, I need to have the origin of the contact displayed from the other
sheet. For instance, I have John Doe, 1234 What Street, What City, etc. in
sheet 2. I need to find the same John Doe in sheet 1 and have whatever is in
the "Origin" column of sheet1 displayed in the "Origin" Column of sheet 2.

"Bernard Liengme" wrote:

Look at VLOOKUP - this will link the two files. Come back if you have
questions; we can show you how to use Paste Special to break the link
between the two files
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Angela" wrote in message
...
I have 2 workbooks. The first workbook is a compilation of approximately
15,000 contacts. The second workbook is a copy of the first. Someone
eliminated a very important column in the second workbook. This column
contained the employee name that the contact originated from. I can not
just
go back and paste the original column in to the second workbook, because
there have been multiple revisions, deletions and additions to the second
work book.

I need a way to match each name in the second workbook to their name in
the
original workbook so that I can capture the origin for that contact name
which is only contained in the first workbook. Any idea how I can do
that?

Well €“ Im not sure. Here is the scenario:

I have a worksheet called €œOriginal€� and I have another worksheet called
€œFinal€�

The column names in €œOriginal€� are List Origin, Title, FirstName, LastName,
Title, etc.
The columns names in €œFinal€� are exactly the same (No Phone or Fax numbers,
however).
The exception is there is nothing in the €œList Origin€� column of the €œFinal€�
worksheet.
The column range in €œOriginal is €œA2 to S17752€�
The column range in €œFinal€� is €œA2 to P11905€�
I need to search the First Name and Last Name in €œOriginal€� and where they
match return the €œList Origin€� for that person in €œFinal€�

I have tried different Vlookup formulas, and I just dont seem to be able to
make it happen. What do you think?


"David McRitchie" wrote:

Please explain why VLOOKUP would not work for you.
ttp://www.mvps.org/dmcritchie/excel/vlookup.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Angela" wrote in message ...
Ok - this is almost what I need. Except that for each contact name in the
one sheet, I need to have the origin of the contact displayed from the other
sheet. For instance, I have John Doe, 1234 What Street, What City, etc. in
sheet 2. I need to find the same John Doe in sheet 1 and have whatever is in
the "Origin" column of sheet1 displayed in the "Origin" Column of sheet 2.

"Bernard Liengme" wrote:

Look at VLOOKUP - this will link the two files. Come back if you have
questions; we can show you how to use Paste Special to break the link
between the two files
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Angela" wrote in message
...
I have 2 workbooks. The first workbook is a compilation of approximately
15,000 contacts. The second workbook is a copy of the first. Someone
eliminated a very important column in the second workbook. This column
contained the employee name that the contact originated from. I can not
just
go back and paste the original column in to the second workbook, because
there have been multiple revisions, deletions and additions to the second
work book.

I need a way to match each name in the second workbook to their name in
the
original workbook so that I can capture the origin for that contact name
which is only contained in the first workbook. Any idea how I can do
that?