excel

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

Vertical Index Match Vert Index Match

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

Horizontal Index Match

Horizontal Index Match Horizontal Index Match

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

This modified text is an extract of the original Stack Overflow Documentation created by the contributors and released under CC BY-SA 3.0 This website is not affiliated with Stack Overflow