Cacher is the code snippet organizer for pro developers

Check If One Column Value Exists in Another Column

=IF(ISERROR(VLOOKUP(A2,$B$1:$B$1857,1,FALSE)),FALSE,TRUE)

Ref: https://www.got-it.ai/solutions/excel-chat/excel-tutorial/vlookup/check-if-one-column-value-exists-in-another-column

CREATE SQL INSERT STATEMENTS FROM A SPREADSHEET

="Insert into Users (userid,first,last) VALUES ("& A2 & ","& CONCATENATE("'",B2,"'") &", "& CONCATENATE("'",C2,"'") &");"