I am using vlookup, and I have about 20 columns of stats I want to look up. For the first stat, I am using the vlookup in
column AJ, to look up stats in column C. This is the code I am using.
=IF(LEN(AH2)>1,VLOOKUP(AH2, $A$2:$AC$31, 3, FALSE),VLOOKUP(AG2,$A$2:$AC$31,3,FALSE))
Now, I could alter this code manually when I put it in in the adjacent columns after AJ, like AK, AL, AM, etc, to look up the
stats in Column D, E, F, etc, but I would rather just copy it horizontally to the right.
Basically, here is the
problem. When I copy the code a column to the right, almost everything in the formula changes to a column to the right, which
is a problem.
This is the code after it gets copied.
I put in bold everything that changed when I copied it a column over, but that shouldn't change. And in italic, the number 3
specifying which column to look up data from, didn't change, when it's the part that needs to change.
wondering how i can automatically copy the formula into 20 more columns, to look up my other 20 stats, and have the number 3
change for each other column (so 4, 5, 6, 7, etc), without the stuff in bold changing. How do I do this?