cant figure out the proper contain function configuration

I am working out of 2 different sheet tabs

1st sheet:
I have 3 columns of data all in different cells. Column 1 is the last name,First name. Column 2 is the spouse name. Column 3 is ID number

ex. column 1- Smith, Joe column 2 - Nancy column 3 - 100

2nd sheet:
I have one column of data and need another. Column 1 is the combined last name,first name and spouse name

ex. column 1 - Smith, Joe and Nancy

What I need to do is figure out a formula that will take the ID number that corresponds with the couple on sheet 1 and match it up to the same couple in sheet 2. It has to be exact though. If there was a name on the first sheet that isnt on the second it must come back with an error message.


HELP ME PLEASE!

Can you upload example workbook please?

Please make sure to avoid private data.

Ok I have uploaded the doc. Also another note is that the last names will be in alphabetical order. The first sheet is suppose to be the master list. Meaning that names on first sheet will be on the second but not necessarily the opposite.

Thanks