Enter the below into cell B2 and extend down. A2 is the lookup value, use dollar sign $ to lock to values on sheet 2, reference column 2 on sheet 2 and enter 0 for text. Sheet 1 Sheet 2
Tag: vlookup
Search Column In Excel For Values That Do Not Exist
Enter the below into cell B2 and extend down to B5 to display values in column A that do not exist in column C To use whole column C instead, remove header and enter the below