Hi Martha,

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

what's your formula in the ninth cell. on the first row?

When I copy the nine cells down,

whats your formula in the ninth cell, on the last row?

with that we can see what is your lookup value and column references.

regards
--
*****
birds of the same feather flock together..



"Martha" wrote:

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