Images from Excel It In a Minute video #8.
VLOOKUP forward – left to right
VLOOKUP
VLOOKUP for reverse lookup
VLOOKUP
VLOOKUP with CHOOSE for reverse lookup
VLOOKUP_CHOOSE