3 Reasons Why INDEX MATCH Is Better Than VLOOKUP
By Wyn Hopkins
VLOOKUP has met it’s match!
Here are 3 reasons why you should use INDEX/MATCH instead of VLOOKUP:
- You can “lookup to the left”
- You don’t get incorrect results when a column is inserted or deleted from your data
- When used in conjunction with Tables, the formulae are a lot more meaningful.
And here are the steps for easy implementation:
- Copy this formula then go into Excel / File>Options>Proofing>Autocorrect
- In the replace box type iii, then in the with box paste the formula
- Whenever you need a better alternative to vlookup just type iii (autocorrect kicks in), and then double click on each piece of text to select the appropriate column/cell
Alternatively, download our free Excel Ribbon (The Great 48 toolbar) which includes a button o put this formula in for you automatically.