Excel lookup master list to find missing or found records
Something like below will help in finding a value in a master list and report if the input is missing or found in the master list.
Sample
=IF(ISNA(MATCH(C2,A2:A15,0)), “Missing”, “Found”)
Format
=IF(ISNA(MATCH(value,array,0)), “Missing”, “Found”)