Formula To Check if a Cell Value Exists in Another Column (Excel, Libre Office Calc, Google Sheet)
Learn how to check if a value in one cell exists in a different column. This will work for Mircosoft Excel, Libre Office Calc, & Google Spreadsheet.
Here is the formula you will need- If Cell Is In Another Column:
=NOT(ISERROR(MATCH(A2,$B$2:$B$1001,0)))