Compare and Match two values in two databases

Solution 1:

You can try to add auxiliary column for example:

Then enter this formula:

=IF(COUNTIF(Sheet2!$C$2:$C$14,Sheet1!A2&Sheet1!B2)>0,"True","False")

Solution 2:

You can use Array Formula with & Operator on the two columns to combine the same and run MATCH function on that Array.

In below screenshots. In Sheet 1 Formula in D3 is

=IF(ISNUMBER(MATCH(B3&C3,Sheet2!$F$3:$F$13&Sheet2!$G$3:$G$13,0)),"True","False")

Create an Array Formula by pressing CTRL + SHIFT + ENTER from within the formula bar. The formula shall now be automatically enclosed in curly braces. This step is important. If you do not create an Array Formula it may not work correctly.

Drag down the formula up to the intended rows in Sheet1 Table.