This video explain how to use " Index Match " Function in instead of "Vlookup" Function to locate a particular data in Microsoft Excel spreadsheet. Vlookup Function is used to look for a particular data in Excel and then pull it up. This requires multiple arguments and it gets complex as the data gets complicated. This is not the case with Index Match Function. it's simple and Easy to use to perform the same analysis without having the caveats of Vlookup.
#indexmatch
#exceltutorial #vlookup