Index Match for Excel

Introduction#

A more versatile alternative to VLOOKUP. An Index Match packs the power of a Vlookup and Hlookup in one formula. You also do not need to know which number column/row the information is. Due to this, deleting columns/rows will not mess up the formula.

Vertical Index Match

=INDEX(A1:A3,MATCH(E2,C1:C3,0))

Horizontal Index Match

=INDEX(A1:C1,MATCH(E2,A3:C3,0))