Images from Excel It In a Minute video #8.
VLOOKUP forward – left to right

VLOOKUP for reverse lookup

VLOOKUP with CHOOSE for reverse lookup