Same Lookup Value, Multiple Corresponding Values

[mlach]

Hello,
This is my first post on the forum so I apologize if I am lacking in any details needed to assist me. I don't know if what I need is possible or not, but I figured I'd give it a shot since Google hasn't provided me with any results.

I have attached a sample spreadsheet with 'All Actions' with of all the information I have and 'Name List' sheet with the ideal results from the information I have.

So, what I need is to return only the names that have "Annual Meeting" in the Name List sheet and if they do, then it says "yes" otherwise leaving the cell blank and so on down the list for each name that shows up. I want to know what names are assigned what actions.

The trouble I am having with this is the fact that the names inconsistently repeat based on the number of actions. The more actions, the more times the name is repeated in the first column. I tried playing around with INDEX and MATCH but with no luck with my Excel skills.

I would appreciate any feedback or help with this and thank you in advance!

[Pete_UK]

Put this formula in cell B2 of the NameList sheet:

=IF(COUNTIFS(Actions!A:A,A2,Actions!B:B,B$1)>0,"yes","")

then copy down.

Hope this helps.

Pete

[mlach]

Thank you very much Pete! This is perfect!