Check Value Exists With Countif

1 minute read When checking if a value exists in a range, using COUNTIF is quicker, easier and less prone to errors. This table shows the returning values for each formula which you can paste to C2 and D2 and drag down: C2: Countif: =COUNTIF($A$2:$A$10, B2) D2: Vlookup: =VLOOKUP(B2, $A$2:$A$10, 1, 0)   A B … Read more