If you're still receiving the "locked" error, see Excel file is locked for modifying for more solutions to this problem.Excel quickly creates a calculated column and copies the formulation down the whole column to suit your needs, altering it for each row.For more info on resolving #N/A errors in VLOOKUP, see How you can proper a #N/A mistake while