Why INDEX MATCH is Better Than VLOOKUP

This is good article to more utilize your excel formula with using INDEX MATCH, benefit of that are :



1. More flexible, if in vlookup you must put your reference in left side, with INDEX MATCH you can put reference in left or right site in your array reference.

2. Faster calculation, with spesific array you have set, INDEX MATCH calculation will be faster than VLOOK UP.



Why INDEX MATCH is Better Than VLOOKUP:



'via Blog this'



Thank you

FA