0Avoid VLookup function in excel, instead use index and match combination.
Reason:
1) Index and Match combination will be faster than Vlookup function. In order to proof this you can create 1000 rows use vlookup to get the value, record the time. Then use index and match combination and record the time. Index and match will take less time when compare to vlookup.
2) Using index and match we look value from right side as well as left side of the array. Using VLookup we can not look value from left side of lookup array
3) Using index we can change look range dynamically.
