COUNTIF to find how many VLOOKUP finds
Don't miss that you can use Excel's COUNTIF formula to find how many entries in a given range of cells do not match a given value. So, in this example we have used VLOOKUP to find where the values in column A appear in column F.
![](https://static.wixstatic.com/media/af7fa4_b426eaae182f4ffc841bcb49b600e4bc~mv2.png/v1/fill/w_930,h_718,al_c,q_90,enc_auto/af7fa4_b426eaae182f4ffc841bcb49b600e4bc~mv2.png)
Comments