Buy Dideo Subscription
How to Use COUNT IF in Place of VLOOKUP Function in Excel? Count if function can be used in place of VLOOKUP sometimes when you just need to know if any value exist in the data table or not. It can become very short and sweet alternative to Vlookup when you only need to know if the value exist in the data or not. Count if will result in number(1,2,3,4..) that is the exact place of that lookup value in the table. This way you will not have to use vlookup and can get rid of it if your purpose is to find the existence of the value. It's easier, Faster and error free rather then #NA errors in VLOOKUP which you againg have to resolve it by using iferror option. When you have to lookup the same value in multiple ranges still this can be used. For multiple range lookup we need to use countifs. By default count if function will look for exact match in the range for the value. if it finds the value then it will return the number(count) of the value in range if not then, it will return zero that means the value does not exist in the table. The best part is you can use multiple ranges for a single value upto 127 times in the sheet. There are only two arguments in count if function first is range where you need to look for the value and second is value itself. But in VLOOKUP we have to insert more then 3 arguments carefully. When count if returns 0 that means the value does not exist in table. Its that simple. Countif function will not only return the number but also it will show how many times it exist in the table (1 time, 2times, three times) but VLOOKUP stops at when it find the value for first time, Vlookup will not invoke the repeting values. For More Interesting Stuff Visit to My new website: http://mytoptenlist.in #VlookupinHindi #VlookupAlternative #EasyExplain
