Comparing Rows in Excel Between 2 Sheets.

[Brendan007]

Hello,

I have a master list of data and a bunch of smaller lists. The data in the master should contain all of the data in the smaller lists.

I need a formula to return a yes or no if a row in the master is represented in the smaller list. Think about it this way: I'm trying to check if a row of data in the master matches exactly in the smaller list it's being compared to.

I've added a photo explaining more.

https://ibb.co/iOUKUd

 

[Robby19]

You have already posted this question. Please refer to the previous post. https://www.mrexcel.com/forum/excel-questions/1059735-comparing-1-row-group-rows.html

 

[Peter_SSs]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.