Copy a formula without offset
Solved
aziz_alg80
Posted messages
427
Status
Membre
-
aziz_alg80 Posted messages 427 Status Membre -
aziz_alg80 Posted messages 427 Status Membre -
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
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 réponse
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
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
aziz_alg80
Posted messages
427
Status
Membre
22
Thank you, Sylvlau, that's exactly the trick I was looking for. See you soon.