Duplicating formulas in Excel

Hello experts,

In an excel cell, I have:

=VLOOKUP(A2;A85:C331;2;FALSE)

In the below cell, it should be:

=VLOOKUP(A3;A85:C331;2;FALSE)
=VLOOKUP(A4;A85:C331;2;FALSE)
=VLOOKUP(A5;A85:C331;2;FALSE)
.
.
.
It should increase the first parameter, with keeping second and third parameters without any change.

How to do so?
MuhajreenAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
Change your formula to this:

=VLOOKUP(A2;A$85:C$331;2;FALSE)

jppinto
0
 
jppintoCommented:
This way you can copy down the formula and it will "fix" the row number on the second and third parameters while incrementing the first.
0
 
jppintoCommented:
Thanks for the grade! :)

regards,

jppinto
0
 
pony10usCommented:
@jppinto:

Am I missing something or shouldn't it be

=VLOOKUP(A2,$A$85;$C$331;2;FALSE)

Just for readability and if you moved the column left or right without changing the source column from A then it would still point to A.

Just asking.

:)

Pony
0
 
jppintoCommented:
Yes, if you plan to move the formula from the actual column to another column, you should fix also the column reference but the author didn't mentioned he wanted to copy the formula to other columns, only to other rows. That's why I provided the solution needed for the case that was presented.

Thanks anyway for you post.

jppinto
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.