Tutorial by Examples

Vertical Index Match =INDEX(A1:A3,MATCH(E2,C1:C3,0))
Horizontal Index Match =INDEX(A1:C1,MATCH(E2,A3:C3,0))

Page 1 of 1