Excel Formula that will only return data from tab 2 if it is different than tab 1

[p3gladiator]

Hi Everyone,
I was hoping that someone could help me, please. I have a spreadsheet with 2 tabs -
Tab 1 contains employee demographics
Tab 2 contains the dependent demographics.
I need a formula for Tab 1 that will return the addresses of Tab 2 if different than the employees. I will be using the Employees Name and or SSN. This would be easy peasy if the employee had only 1 child but, some have multiple children that may have different addresses.
Can anyone help me?
thanks so much!

 

[Sufiyan97]

Post some rows of data to show as example

 

[p3gladiator]

I need the address in orange from tab 2 to be returned in the Dep address cell in orange on Tab 1.

 

[p3gladiator]

I need the address in orange from tab 2 to be returned in the Dep address cell in orange on Tab 1.

 

[JEC]

If there could be more different addresses you need this formula. Pull down for multiple results

=IFERROR(INDEX(Sheet2!$C$3:$C$5,AGGREGATE(15,6,ROW($1:$3)/((Sheet2!$A$3:$A$5=Sheet1!$A$3)*(Sheet2!$C$3:$C$5<>Sheet1!$B$3)),ROW(A1))),"")

 

[p3gladiator]

If there could be more different addresses you need this formula. Pull down for multiple results

=IFERROR(INDEX(Sheet2!$C$3:$C$5,AGGREGATE(15,6,ROW($1:$3)/((Sheet2!$A$3:$A$5=Sheet1!$A$3)*(Sheet2!$C$3:$C$5<>Sheet1!$B$3)),ROW(A1))),"")[/CODE]

Thank you so much, this is amazing.

 

[JEC]

You’re welcome!?

 

[smozgur]

Thank you so much, this is amazing.

So, that's the reason I switched the marked solution with that post in this question.

@p3gladiator, please mark the solution post in the future instead of your last post (unless you post your own solution) to help future readers. Thanks.