ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help merging excel sheets (2007) on a common field (https://www.excelbanter.com/excel-worksheet-functions/267344-help-merging-excel-sheets-2007-common-field.html)

campanellisj
Help merging excel sheets (2007) on a common field
 
Good afternoon and thank you for any help offered.

I have an excel form with two sheets (attrs pull & edas pull) each of these sheets have a common field (SSN).
one sheet has over 4000 SSN's while the other has 200. I need to merge only the common SSN's into a third sheet. I have researched the Vlookup function but these SSN's change constantly so it's not a field that I can use a vlookup on that I am aware of. Is this even possible?

wickedchew
Quote:
Originally Posted by campanellisj (Post 961193)
Good afternoon and thank you for any help offered.

I have an excel form with two sheets (attrs pull & edas pull) each of these sheets have a common field (SSN).
one sheet has over 4000 SSN's while the other has 200. I need to merge only the common SSN's into a third sheet. I have researched the Vlookup function but these SSN's change constantly so it's not a field that I can use a vlookup on that I am aware of. Is this even possible?
Attach your files here as a zip file. Someone might be able to help you out... including me!


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com