CODEWITHSUNDEEP
excelvbaexcel-formulaexcel-2010excel-2007
Navneet Singh
Navneet Singh

Reputation: 19

Merge data sets

Problem statement: I have data in sheet1 and sheet2. I need to merge these data on basis of Unique id's(UID) which are mentioned for both data set. I need to merge "Reviewer" and "local" data in sheet1 data set.I have tried Vlookup but did not work for me. Below is the pic mentions data set 1 and data set 2 with final output expected

enter image description here

Upvotes: 0

Views: 102

Answers (1)

user616324
user616324

Reputation: 65

To do this, you must use Vlookup in data set 2, creating new columns with Vlookup for each data you want from data set 1. My excel is in Portuguese, the image shows the form PROCV, but in English is VLOOKUP.

=VLOOKUP($I3,$A$3:$E$100,2,FALSE)

enter image description here

enter image description here

With all the data gathered in data set 2, select all data from data set 2, and create a pivot table by ordering the data the way you want.

enter image description here

Upvotes: 1

Related Questions