software

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 quot;Originquot; column of sheet1 displayed in the quot;Originquot; Column of sheet 2.

quot;Bernard Liengmequot; wrote:

gt; Look at VLOOKUP - this will link the two files. Come back if you have
gt; questions; we can show you how to use Paste Special to break the link
gt; between the two files
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Angelaquot; gt; wrote in message
gt; ...
gt; gt;I have 2 workbooks. The first workbook is a compilation of approximately
gt; gt; 15,000 contacts. The second workbook is a copy of the first. Someone
gt; gt; eliminated a very important column in the second workbook. This column
gt; gt; contained the employee name that the contact originated from. I can not
gt; gt; just
gt; gt; go back and paste the original column in to the second workbook, because
gt; gt; there have been multiple revisions, deletions and additions to the second
gt; gt; work book.
gt; gt;
gt; gt; I need a way to match each name in the second workbook to their name in
gt; gt; the
gt; gt; original workbook so that I can capture the origin for that contact name
gt; gt; which is only contained in the first workbook. Any idea how I can do
gt; gt; that?
gt; gt;
gt;
gt;
gt;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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Angelaquot; gt; wrote in message ...
gt; Ok - this is almost what I need. Except that for each contact name in the
gt; one sheet, I need to have the origin of the contact displayed from the other
gt; sheet. For instance, I have John Doe, 1234 What Street, What City, etc. in
gt; sheet 2. I need to find the same John Doe in sheet 1 and have whatever is in
gt; the quot;Originquot; column of sheet1 displayed in the quot;Originquot; Column of sheet 2.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt; gt; Look at VLOOKUP - this will link the two files. Come back if you have
gt; gt; questions; we can show you how to use Paste Special to break the link
gt; gt; between the two files
gt; gt; best wishes
gt; gt; --
gt; gt; Bernard V Liengme
gt; gt; www.stfx.ca/people/bliengme
gt; gt; remove caps from email
gt; gt;
gt; gt; quot;Angelaquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I have 2 workbooks. The first workbook is a compilation of approximately
gt; gt; gt; 15,000 contacts. The second workbook is a copy of the first. Someone
gt; gt; gt; eliminated a very important column in the second workbook. This column
gt; gt; gt; contained the employee name that the contact originated from. I can not
gt; gt; gt; just
gt; gt; gt; go back and paste the original column in to the second workbook, because
gt; gt; gt; there have been multiple revisions, deletions and additions to the second
gt; gt; gt; work book.
gt; gt; gt;
gt; gt; gt; I need a way to match each name in the second workbook to their name in
gt; gt; gt; the
gt; gt; gt; original workbook so that I can capture the origin for that contact name
gt; gt; gt; which is only contained in the first workbook. Any idea how I can do
gt; gt; gt; that?
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt;
Well – I’m 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 don’t seem to be able to
make it happen. What do you think?quot;David McRitchiequot; wrote:

gt; Please explain why VLOOKUP would not work for you.
gt; ttp://www.mvps.org/dmcritchie/excel/vlookup.htm
gt;
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Angelaquot; gt; wrote in message ...
gt; gt; Ok - this is almost what I need. Except that for each contact name in the
gt; gt; one sheet, I need to have the origin of the contact displayed from the other
gt; gt; sheet. For instance, I have John Doe, 1234 What Street, What City, etc. in
gt; gt; sheet 2. I need to find the same John Doe in sheet 1 and have whatever is in
gt; gt; the quot;Originquot; column of sheet1 displayed in the quot;Originquot; Column of sheet 2.
gt; gt;
gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;
gt; gt; gt; Look at VLOOKUP - this will link the two files. Come back if you have
gt; gt; gt; questions; we can show you how to use Paste Special to break the link
gt; gt; gt; between the two files
gt; gt; gt; best wishes
gt; gt; gt; --
gt; gt; gt; Bernard V Liengme
gt; gt; gt; www.stfx.ca/people/bliengme
gt; gt; gt; remove caps from email
gt; gt; gt;
gt; gt; gt; quot;Angelaquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt;I have 2 workbooks. The first workbook is a compilation of approximately
gt; gt; gt; gt; 15,000 contacts. The second workbook is a copy of the first. Someone
gt; gt; gt; gt; eliminated a very important column in the second workbook. This column
gt; gt; gt; gt; contained the employee name that the contact originated from. I can not
gt; gt; gt; gt; just
gt; gt; gt; gt; go back and paste the original column in to the second workbook, because
gt; gt; gt; gt; there have been multiple revisions, deletions and additions to the second
gt; gt; gt; gt; work book.
gt; gt; gt; gt;
gt; gt; gt; gt; I need a way to match each name in the second workbook to their name in
gt; gt; gt; gt; the
gt; gt; gt; gt; original workbook so that I can capture the origin for that contact name
gt; gt; gt; gt; which is only contained in the first workbook. Any idea how I can do
gt; gt; gt; gt; that?
gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt;
gt;
gt;