The best replacement for index match is vlookup.

The best alternatives to index match are rated as following:
★★★★★  vlookup
★★★  offset match
★★★  sumproduct
★★★  sumif
★  hlookup
★  vlookup excel

Your alternative for index match is not listed? Suggest!
Speaking about index match, one probably shouldn't forget about indirect.

Other search terms related to index match and their ratings are:
★★★★★ indirect
You have in mind a companion for index match and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of index match in all years. Click on graph for more.
index match
vlookup
offset match