excel Vertical Index Match


Example

Vertical Index Match Vert Index Match

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