The RECHERCHEV (VLOOKUP) function looks up a value in the first column of a table and returns the value from another column identified by its number. Its fourth argument is FAUX (FALSE) (or 0) for an exact match. It only looks to the right and is fragile if columns are inserted; RECHERCHEX is more recent.
Example
=RECHERCHEV(A2;$E$2:$G$50;3;FAUX)