Comparing data between two tabs in a single excel sheet

[MATTHEW_KING1]

Hi,

I am trying to find a way that I can add a column to one tab which brings back "yes" if criteria are matched across multiple cells between the two tabs. Is this even possible? Appreciate any help in advance.

[atcodedog05]

Hi @MATTHEW_KING1 

Just overwrite to the sheet like this.

Hope this helps : )

[MATTHEW_KING1]

Thanks @atcodedog05 , just trying to get my head around this. Please bear with me. The PET = "No" formula and PET = "Yes" formula tools, how are they constructed to bring back a "Yes" or "No"?  I dont see any logic entered for the result.

[NikyN]

Hello @MATTHEW_KING1, it is based on the JOIN Tool. Anything that is coming from J Anchor --- should be 'Yes' as items found in both datasets. In case of RIGHT Anchor, it should be 'No' as items not found in Sheet1.

Best Luck!

Niky

[atcodedog05]

Hi @MATTHEW_KING1 

Configure the output tool to overwrite the 2nd sheet this way you will get the whole data including the new column.

Hope this helps : )