Compare values on two columns on worksheet 1 to two columns on worksheet 2 to find match

I have been searching this forum and all over the internet trying to find a solution and no luck.

This is what I am trying to do.

I have these values in two columns on worksheet 1

Table Name Row Count
Asset_Archive 972,193
Asset_Interface_Archive 3,597,538
Asset_Summary_Archive 5,291,127

and I want to compare them to in two columns on worksheet 2

Table Name COUNT
Asset_Archive 972,193
Asset_Interface_Archive 3,597,538
Asset_Summary_Archive 5,291,127

and display on worksheet 1 the value "Yes" in a column called Check Confirmed if a match was found for both columns on both worksheets, but no luck. I was hoping someone on here has done this kind of match check before.

Any pointers to the correct formula would be great. As I am pulling my hair out trying to figure this one out.

Are you needing to check only if the values are identical? i.e. Asset_Archive 972,193 from sheet #1 is equal to Asset_Archive 972,193 on sheet 2?

I suppose a simple IF statement could work, let's say that the Asset_Archive value is in cell B2 on both worksheets and the check cell with "Yes" is in A1.

In cell A1:
=IF($b$2='Sheet2'!$b$2,"Yes","")

I'm sure this answer is probably missing what you are looking to do, however if you could explain further, that will help.

That is part of it, so what I need to do is Column A on worksheet 1 is equal to Column A on worksheet 2 and if they match then check to see if the value in Column B on worksheet 1 also matches Column B on worksheet 2, if they all match then put the value "Yes" into Column C on worksheet 1, else put "No"

I need to explain a little further.

On worksheet 1 I need to compare the values in Column A to the entire list in Column A on worksheet 2 and if their is a match compare the values in Column B on WS1 to Column B on WS2 and if they also match then "Yes", else "No".

What about nested IF statements?

=IF($a$2='Sheet2'!$a$2,IF($b$2='Sheet2'!$b$2,"Yes","No"),"No")