yogi_Check If Names In LIST2 Are In LIST1

Google Spreadsheet   Post  #2091

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-05-2016

question by: allan starr:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/uGb8TtTyhHw;context-place=mydiscussions

a function for checking a list of names against a subset list of names?

Hi! I have a list of names in a spreadsheet, and a smaller second list of names which is a subset of the first. (both in two columns ie first name, surname). I need a function/formula that will simply check each full name in the complete list (ie both columns) to see if it appears in the subset list (which is also in two columns), and if it does, to note that somehow ie put some value/symbol/text in the column next to the name in the complete list. Any tips on which formula/function will do this? [If necessary I can merge the first name/surname columns but I'd rather not.]