Find 2 values in adjacent columns simultaneously
 

Hi All,

Thanks to you all for your codes and for pointing out better ways of coding.
What I ended up doing is concatenating the two columns that I wanted to find
adjacent values. Made that the searchable range and it works.