Excel Formula

[Cesar DelRosal]

 In column A, EID, I want the employee's SSN (Column D) to show up at all times.  So in A4 (Alice Jones), I want her husband, who is the employee, Jim Jones' SSN should appear.  Same for child.  Is there a formula for this?

	A	B	C	D	E
1	EID	Last Name	First Name	SSN	Relationship
2		Smith	Alice	111-11-1111	Employee
3		Jones	Jim	222-22-2222	Employee
4		Jones	Alice	333-33-3333	Spouse
5		Jones	James	444-44-4444	Child

[#2]

In the example provided you can get it to work via the Last Name column, but if you have more employees with the same last name it will not work. You need extra data.