I have a large list of ID#'s with corresponding data. See attahced mock up.
I've tried messing around with some if, match/index and vlookup functions, but nothing seems to come close to what I'm looking for on their own.
What I want to do is if the ID# in Col. "C" matches another ID in the same column, to return the relationship status from "A" and name from "B" into "D"
So for row 1 it should return: "Self JIM, Spouse Elizabeth, Child Child1, Child Child6, Child Child11"
Thank you for any and all hints, tips and tricks!
Bookmarks