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?
|