Using combined If and And functions on different datasets

hi there,
i have a list of 300 attendees who attended an event. I want to cross compare against a master database of 2000 people, to see a) how many of the 300 attendees are in the master list and b) of those in the master list, which location they are from. I can't seem to be able to do this. I'm using the 2000 master list name as the main spreadsheet), the name is in column E. In column H I've copied and pasted the names of the 300 attendees. In column I, I've said: =IF(H2:H320=E2:E2150,YES,"")) to try and see that if they appear as an attendee, do they appear on our database too. This doesn't seem to work (and I know about 200 of the 300 people do match our database, so I know this is wrong).

then, I also want to know of those in column H (attendee name), if they are in our master list, which region are they from (region in column G). I cannot for the life of me figure out this bit! help!
thanks