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?
David McRitchie said:
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 said:
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.
