Urgent! Match two sheets data together by a common cell??
Posted by Diana on January 25, 2001 7:20 AM
Hi - I really need your help. I have been trying for weeks to solve this problem.
In a nutshell. We have two files that contain people and their demographic data. Both sheets have a common column (id code) for each person. But the people are not the same on each sheet (many will overlap but not all).
How do I considate both sheets to list all the person's information in one row by matching the id code on each sheet?
ie - Sheet 1 has #1 Jane Smith Address
Sheet 2 has #1 Jane Smith Phone Date of Birth
I want Sheet 3 to have #1 Jane Smith Address, Phone, DOB