Match data from 2 separate sheets based on a common variable

**CatherineRotman** · 10-18-2019, 06:06 PM

Hello!

I am hoping someone will be able to guide me in the right direction of how to go about the following, assuming it is possible.

In my scenario, I have 2 different reports and am looking to match up some data based on one common variable (column) between each rerport.

Report 1 lists hundreds of names of properties in a column, with services offered at each property in another corresponding column.
Report 2 lists thousands of email recipients in a column, with their corresponding properties in another corresponding column.

The common variable is the properties. I want to be able to add a column on report 2 showing/linking the services to the corresponding property names as they are listed beside all the user emails.

Is this even possible, and if so what would be the process? I was exploring the VLookup but before I spent extensive time invested in YouTube tutorials, I decided to turn to this forum.

If anyone is able to assist I would GREATLY appreciate it!!!

**alansidman** · 10-18-2019, 06:23 PM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Vlookup may be a viable means or Power Query. Seeing sample data will determine which way may be best for you.

**CatherineRotman** · 10-18-2019, 08:47 PM

Thanks for the fast response! Ok I uploaded a sample sheet of what I am trying to accomplish here.

**alansidman** · 10-19-2019, 12:38 AM

In C2 int the After worksheet type =VLOOKUP(B2,'Before (Sheet B)'!$A$2:$B$8,2,FALSE) and copy down.

**CatherineRotman** · 10-19-2019, 07:20 PM

That worked!!! Cannot thank you enough!!

**alansidman** · 10-19-2019, 07:28 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Match data from 2 separate sheets based on a common variable

LinkBack

Thread Tools

Rate This Thread

Display

Match data from 2 separate sheets based on a common variable

Re: Match data from 2 separate sheets based on a common variable

Re: Match data from 2 separate sheets based on a common variable

Re: Match data from 2 separate sheets based on a common variable

Re: Match data from 2 separate sheets based on a common variable

Re: Match data from 2 separate sheets based on a common variable

Thread Information

Users Browsing this Thread

Similar Threads

using index match to compare numbers on different sheets based on a common criteria

[SOLVED] 2 Sheets data combined into output sheet with match 1 field common

Cross match data between workbooks based on common values

[SOLVED] Pulling Data from two separate sheets based on criteria on both those sheets

Match Common Variable Across Sheets and Copy a Variable

Copy variable data from multiple sheets into separate sheet when cell value greater than 0

Extract data to separate sheets based on separate criteria

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions