Pasting Forumulas without changing row and/or column reference

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I want to paste a lookup formula from the first row of a column through all
the rest of the rows in that column. The problem is when pasting it is
increasing the row number from the original lookup data range by 1 row for
each row. How can I stop that? I have 1,500 rows and I don't want to have
to do this manually.
 
Put a $ in front of the address that you don't want to change. Something
like:

=$a$1*4

Regards,
Fred.
 
I want to paste a lookup formula from the first row of a column through all
the rest of the rows in that column. The problem is when pasting it is
increasing the row number from the original lookup data range by 1 row for
each row. How can I stop that? I have 1,500 rows and I don't want to have
to do this manually.
Click to expand...

Try using absolute addressing rather than relative addressing for you
lockup data range. Like this

=LOOKUP(X1, $A$1:$A$100) rather than =LOOKUP(X1, A1:A100)

Hope this helps / Lars-Åke
 
Back
Top