Get accurate results with Index and Match | How to use Index and Match
Have you ever experienced , vlookup fetches you an incorrect result when you add (or delete) a row or column?. If yes, then this video is for you.
Index and Match is superior to Vlookup. Index will show you the position of the result. Match will look up the value that is specified and compare it with the value from the table.
To know more about highlighting rows and columns, please follow this link
• How to highlight intersect columns an...
#Excel #index #match #karpagamexcel
Keep Watching,Keep Learning.