Copying absolute VLOOKUP

[Guest]

I have the following formula:

=IF(ISNA(VLOOKUP($A3,'HR Feed (HC and
Co-Location)'!$A$3:$R$566,5,FALSE)),"",VLOOKUP($A3,'HR 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

 

[Don Guillett]

Just paste or grab the fill handle and drag down.

 

[Guest]

Nope - doesn't work. Same result - It's copying the value instead of the
formula. Any other ideas? Thanks much

 

[Guest]

Don - tried it and getting the same result. It's copying the value instead
of the formula.

 

[Dave Peterson]

Make sure you recalculate (or set calculation to automatic)

tools|Options|calculation tab

 

[Guest]

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?

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

 

[Don Guillett]

to drag, select the cell>goto the lower right corner>grab the square and
drag>let go at desired point.
to copy> copy> select the cells to copy to >edit>PASTE