what is the difference between index and vlookup?
The Difference Between VLOOKUP and INDEX/MATCH. ... VLOOKUP is a single formula that does all the lookup-and-fetch, but with INDEX/MATCH, you need to use both the functions in the formula. INDEX/MATCH can more advanced lookup – such as lookup to the left of the dataset, make row/column value dynamic, etc.