VLOOKUP lookup_value number not changing

=VLOOKUP(1,’Main Tracker’!A:F,6,FALSE)

 

When I copy this formula down, I want the lookup_value, the “1”, to fill series so when I copy it down I want it to change to “2” and then “3” and etc.

 

Instead the formula just copies exactly as is and I have to manually change the number of the lookup_value.

 

Is there a way to accomplish this?

By: Ricky

Leave a Reply

Your email address will not be published. Required fields are marked *