View original (French)

Copy a formula without offset

Solved
aziz_alg80 Posted messages 427 Status Member -  
aziz_alg80 Posted messages 427 Status Member -
Hello,
In cell B15, I have the following formula:
=LOOKUP(A15,A1:A10,B1:B10)
with the ranges A1:A10 and B1:B10 being a data table, and cell A15 is where a reference will be entered which in turn calls upon this data. My question is as follows:
How can I copy the same formula to cells B16, B17, B18, etc., without shifting the reference to this data table?
Thank you for your attention.

Configuration: Windows XP / Internet Explorer 8.0

1 answer

  1. Sylvlau
     
    Good evening,

    If I understand correctly, you just need to put a $ in front of the reference you want to make static.

    For example: lookup($A$15;A1:A10....)
    in this case A15 will never change.

    Another example: lookup(a$15;A1:A10...)
    in this case, only 15 will be fixed.

    See you soon
    18
    1. aziz_alg80 Posted messages 427 Status Member 22
       
      Thank you, Sylvlau, that's exactly the trick I was looking for. See you soon.
      0