=IF(B3="Spouse", IF(INDEX(B:B, MATCH(C3,C:C, 0))="Primary", INDEX(A:A, MATCH(C3,C:C, 0)), ""), "No Spouse")

A                B              C                  D
Name             Relationship    Address             Spouse
Joe Smith        Primary         432 Park Dr         No Spouse
Michael Turner   Primary         2298 Thompson Rd    No spouse
Sarah Smith      Spouse          432 Park Dr         Joe Smith