Excel VLOOKUP between two columns of words-CodePudding

I have two columns of words (Old list) and (New list) I'm trying to check using the VLOOKUP() function both columns and find which words of the New list doesn't appear in the Old list.

(The answers here is obviously: eyes, john, martha, phone)

I'm giving this simple example to know what VLOOKUP() formula to also apply to a larger sample. In reality I have two columns of over 1000 items. Thanks

CodePudding user response：

=FILTER(F2:F10, ISNA(VLOOKUP(F2:F10,A2:A10,1,FALSE)))

This will filter it down and remove all the N/A values while comparing the 2nd list to the first.

CodePudding user response：

If you would like TRUE/FALSE for each element you can use the following

=ISNUMBER(MATCH(A1,ColumnToSearch,0))