Excel - How can you find the exact match of a table row in a separate table if it exists?
<p>I have a spread sheet with two tables:</p>

<p><a href="https://i.stack.imgur.com/7gcfI.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7gcfI.jpg" alt="enter image description here"></a></p>

<p>I want to find every "row" in table1 that exists as an exact match in table2 using a formula. For example, you can see I have one row in the "matches" table to the right. </p>

<p>So far, I can check for exact matches on a per row basis(this is an Array formula entered using ctrl+shift+enter):</p>

<pre><code>=AND(EXACT(A3:B3,D3:E3)) 
</code></pre>

<p>How can I do that for the entire range in Excel? </p>