I have the following formula:

=IF(ISNA(VLOOKUP($A3,'HR Feed (HC and
Co-Location)'!$A$3:$R$566,5,FALSE)),"",VLOOKUP($A3,'H R Feed (HC and
Co-Location)'!$A$3:$R$566,5,FALSE))

It is copied across to 8 columns with the appropirate column reference
entered twice in each one.

When I copy the nine cells down, using ^C, Edit/Paste special/Formulas, it
copies the resulting value from the first row, instead of the correct lookup
value. Any ideas what I'm doing wrong? Thanks