Hello!
I'm trying to come up with a formula that if a person picks a team # in a drop down, a contact list populates in the cells below
I used vlookup and it's just not exactly what I'm looking for.
I always want 3 people from the team to be listed; but some teams don't have 3 contacts ...
I always want the 4th contact to be the same person
Please see enclosed and thank you for your help!
Bookmarks