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!