Comparing Duplicates for Columns in Separate Sheets

Copper Contributor

I'm comparing data in two columns in two separate sheets, and I'm trying to create a third column that will say "Yes there's a match to this value in the separate sheet" or "no there is not a matching value in the other sheet."

 

For ex. if the data in B2:B194 in sheet 1, matches a cell of data in sheet 2 D2:D134, in the third column say "yes"

1 Reply