How to use the COUNTIF Function Instead of VLOOKUP in Excel HD

Learn how to use the COUNTIF function instead of VLOOKUP to determine if a value exists in a list or range. This video is from the Ultimate Lookup Formulas Course. The course contains over 100 short videos just like this one. Click the following link to learn more about the course. http://www.excelcampus.com/lookups COUNTIF is a really easy function that will allow you to quickly determine how many cells contain a value/criteria in a range. Here are 3 reasons to use COUNTIF instead of VLOOKUP (when you just want to see if a value exists in a range of cells): 1. The COUNTIF function only has two arguments making it really fast and easy to write the formula. VLOOKUP has four arguments. 2. COUNTIF returns the total number of matching values in the range, so you can see if there is more than one matching value. VLOOKUP cannot do this, it only returns the first match. 3. If the value does not exist, COUNTIF will return a zero (0). You do not need to worry about a formula error. With VLOOKUP, the formula would return an error and you would use the IFERROR function to handle the error. Click here to read the entire blog post. http://www.excelcampus.com/functions/how-to-use-countif-instead-of-vlookup