INDEX returns the value of a cell located at a given position in a range, and EQUIV (MATCH) returns the position of a value in a range. Combined, they perform a flexible lookup: EQUIV finds the row, INDEX reads the value in the desired column, wherever it is. They are notably used to look up to the left.
Example
=INDEX(C2:C100;EQUIV(F1;A2:A100;0))