Copying absolute VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Nope - doesn't work. Same result - It's copying the value instead of the
formula. Any other ideas? Thanks much
 
Don - tried it and getting the same result. It's copying the value instead
of the formula.
 
Make sure you recalculate (or set calculation to automatic)

tools|Options|calculation tab
 
Hi Martha,
It is copied across to 8 columns with the appropirate column reference
Click to expand...
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
 
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
 
Back
Top