0Vlookup function has the below limitations.
1. The lookup range should always be on the right-hand side of the vlookup value. This is the biggest limitation.
2. If supposedly you need to look up a value from say 90th column, then lookup function is designed in such a manner that in the background it will search in all the columns before the 90th column and then give you the result from the 90th column. This takes a lot of time if the file size is huge.
INDEX MATCH helps to solve the above problems.
No need to worry whether lookup range is on left or right, you can directly use the Index Match function and get your result at a better speed as compared to Vlookup.
