Good afternoon 

I’m struggling to get formulas to work for me when comparing two data sets. There are four columns to compare and wanting to find if there is a matching “set” in another range of data

So I’ve been trying to do as a two step process where it checks whether the information in Data Set 1 is in Data set 2 unless concat to create unique strings, however what I also require is it then to state if there is no match, is there a match on say 3/4 items and then what is wrong if so. 

Understand this might not be possible but wanted to see if anyone else had any suggestions

​Good afternoon  I’m struggling to get formulas to work for me when comparing two data sets. There are four columns to compare and wanting to find if there is a matching “set” in another range of data So I’ve been trying to do as a two step process where it checks whether the information in Data Set 1 is in Data set 2 unless concat to create unique strings, however what I also require is it then to state if there is no match, is there a match on say 3/4 items and then what is wrong if so.  Understand this might not be possible but wanted to see if anyone else had any suggestions  Read More

​