If Data in one sheet is in the other then create column

pablomtz28

Hello all,

I have two excel sheets. In both excel sheets there is several data, but they both have two certain data that are the same, which is the personal id number and year started. The first sheet has much more data than the other, but all the data in the second sheet can be found in the first one. I want to basically check if I can find the personal ID and date from every row in the second to the first, and add a column at the end of the first stating if found or not. Is there a way to do so? Let me explain with a table.

Data 1

Personal ID	Year Started
0001	2010
0001	2011
0002	2013
0005	2014

Data 2

Personal ID	Year Started
0001	2010
0005	2014

Output

Personal ID	Year Started	Both?
0001	2010	Yes
0001	2011	No
0002	2013	No
0005	2014	Yes

Anyone can help?

AbhilashR

Hi @pablomtz28, you could join the two datasets on Personal ID and Year Started to compare the datasets and write a formula tool downstream to get your Both? column flag. Something like the attached solution.

sample.yxmd