checking 2 values exist in 2 separate ranges

Could any of you clever people help me out?

Got 2 worksheets, each with 3 columns of data. I’m trying to find a formula that will take the info in columns 2 and 3 on one sheet, and check if that data (the exact combo of columns 2 and 3) is also in columns 2 and 3 on the second worksheet, and return a value or true if it is, or false if it isn’t.

 

Could anyone help please??

By: JoWhite

Leave a Reply

Your email address will not be published. Required fields are marked *