In this video I have covered VLOOKUP Function with combination of COUNTIF, where we can insert data from multiple column in to single column, and also covered that how we can use VLOOKUP function on duplicate data in lookup value, if I have duplicate data in lookup value then VLOOKUP will display only first lookup data. I have resolve the same issue via this video.
For more details Please watch this Video till the end, its very important and helpful for your daily worklife.
Count Series Function- https://youtu.be/b-04cbwgDXg
Lookup Data with INDEX+MATCH Function- https://youtu.be/VllDchr6WMI
