# Merge 2 sheets by common data? Ex: sheet 1 has address, no phone. Sheet 2 same and phone

1. ## Merge 2 sheets by common data? Ex: sheet 1 has address, no phone. Sheet 2 same and phone

I am pulling data from Medicare.gov's data site, One sheet has names of nursing home owners by legal name and addresses but no phone numbers, and another sheet has facility names, addresses and phone numbers. Is there a way to merge the two sheets using something common to both, such as the address? (The legal name/business names differ.)

As always, thanks for helping out the "newbies!"

Kathleen

2. ## Re: Merge 2 sheets by common data? Ex: sheet 1 has address, no phone. Sheet 2 same and pho

Kathleen,

This shouldn't be any problem, provided there is some identical piece of info for each business on both sheets. You should upload a small sample of what you're dealing with, so that we can further assist you.

3. ## Re: Merge 2 sheets by common data? Ex: sheet 1 has address, no phone. Sheet 2 same and pho

This can be dealt with the Excel formula using Vlookup. But providing a sample data will even be better to provide a precise solution.

4. ## Re: Merge 2 sheets by common data? Ex: sheet 1 has address, no phone. Sheet 2 same and pho

However, let's say Book 1 has the company name, address, city, zip. Book 2 has the same info but also has a phone number, and contact first name. I want to take the phone number and contact name from Book 2 and merge it into Book 1, which will be my final sheet. I just need step one, two three or a resource on the steps.
Thanks SO much!!

5. ## Re: Merge 2 sheets by common data? Ex: sheet 1 has address, no phone. Sheet 2 same and pho

=vlookup(cell in sheet 1 that has a match in sheet 2,array in sheet 2, column # to bring over, "false" to force exact match)

see attachment: how to use Vlookup.xlsx

keep in mind, you will need to "lock" your selction (\$A\$1:\$x\$x) if your array is in the same workbook, otherwise the array will "slip" as you copy it down the column. Looking up something in a different spreadsheet altogether locks the array automatically.

6. ## Re: Merge 2 sheets by common data? Ex: sheet 1 has address, no phone. Sheet 2 same and pho

Thanks! I will decipher this (I'm a newbie to Excel) and see how I do.
Kathleen

7. ## Re: Merge 2 sheets by common data? Ex: sheet 1 has address, no phone. Sheet 2 same and pho

Originally Posted by KathleenTurnis
Thanks! I will decipher this (I'm a newbie to Excel) and see how I do.
Kathleen

8. ## Re: Merge 2 sheets by common data? Ex: sheet 1 has address, no phone. Sheet 2 same and pho

I'm not making much progress on this on my own. I've attached two datasheets, they have a "provider number" in common (most of them anyway.) I'd like to capture or merge the info on the sheet with phone numbers, ownership info into the "CA-needs phone" sheet (as my final result.) If I can explain further my number in FL is 727-623-0034.
Thank you SO much!!!!
Kathleen

There are currently 1 users browsing this thread. (0 members and 1 guests)