I have inherited two spreadsheets that are linked and a VLOOKUP in one is
referring to a range in the other. The VLOOKUPs all work on the existing
data but as when I add new data, bearing in mind the formatting of the cells
and the order of the lookup range, those do not work. I get the #N/A error.

Any ideas?