VLOOKUP can't find the code

A colleague pulled delivery rates by zone code, but in some rows VLOOKUP returns #N/A even though those codes are in the directory.

Find the cause and fix the formulas in B2:B8.

You can't change the source data in column A: it's exported again every day.