Formula to enter new value in a cell

[Chie019]

Hi, 

I'm trying to find a formula for the sample below that could enter in another cell if the member has dependents or not (Coverage Tier). Like the1st one, the member has family, so I would like to put Family on the coverage tier. Thank you! 

 

[#2]

@Chie019 

=IF(COUNTIFS([MEMBER SSN], [@[MEMBER SSN]], [DEPENDENT SSN], "<>"), "Family", "Individual")