excel Horizontal Index Match


Example

Horizontal Index Match Horizontal Index Match

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