identifier when value is in list or not in list

[dw700d]

The Team A table below has 3 columns. Column 1 is a Director column that identifies the director of the team A member found in column 2. Column 2 is a column for Team “A” team members. Column 3 is a column that shows who the team A member works with.

Team A Table
Director	Team A Member	Works with Name
Amy	Carl	Dave
Amy	Larry	ADAM
Toney	Mike	Dave
Toney	Tom	Adam
Toney	Jerry	KEN
Sam	Nyra	KEN
Sam	Felix	Dave

The organization table below has 2 columns, a column for all members of the organization (this includes members of team A, people team A works with and others) . the second column shows the VP for every member in the organization.

.

Organizational Table
VP	Team Member
Charles	Carl
Charles	Larry
Charles	Mike
Bob	Tom
Bob	Jerry
Bob	Nyra
Stephen	Felix
Abe	Carl
Trevor	Larry
Joe	Mike
Bella	Tom
Karen	Jerry
Mitch	Nyra
Jarvis	Felix

I would like to create a Table that shows me a list of all VP’s and has an identifier that says “Y” if any  value in the team member column from the organizational table is found in the works with name  column of the Team A table, It would say “N”  otherwise.

I would also like the ability to filter those results by the Team A director column in the Team A Table.

Can someone help me with a measure?. I have tried to merge the two tables but that doesn’t work because it gives me a  Y & N value when  VP’s have team members that are both in the works with name column and not on the column

Thanks for your help

[andhiii079845]

If I understand right you :

1) A list of all VP

2) use the related Team Member and look up if the name is found works with name column.

->

VP	Team member	Works with Name
Charles	Carl	not found
Charles	Larry	not found
Charles	Mike	not found

Did you perhaps mean the Team A Member column?

Than you want to filter the Team A Table, how this should work? I do not understand it. You can filter VP, did you mean this? 

Make please a good example with some sample datas 🙂