Posted on

Compare each cell from column A with each cell from column B and column C

Excel Formulas

Compare each cell from column A with each cell from column B and column C

=OR( IF(ISNA(VLOOKUP(A1,B:B,2,0)),FALSE,TRUE),IF(ISNA(VLOOKUP(A1,C:C,3,0)),FALSE,TRUE))