Return data in a corresponding cell if lookup matches

The following is an example that demonstrates how to return data in a corresponding cell if matches in a range of cells.

Lookup from a different sheet:

=INDEX(Sheet1!B$2:B$2667;MATCH(E2;Sheet1!C$2:C$2667;0))

1	=INDEX(Sheet1!B$2:B$2667;MATCH(E2;Sheet1!C$2:C$2667;0))

From the same sheet:

=INDEX(B$2:B$2667;MATCH(E2;C$2:C$2667;0))

1	=INDEX(B$2:B$2667;MATCH(E2;C$2:C$2667;0))

Example:

=INDEX(E$2:E$4;MATCH(A1;D$2:D$4;0);1)

1	=INDEX(E$2:E$4;MATCH(A1;D$2:D$4;0);1)