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

4 thoughts on “VLOOKUP lookup_value number not changing

  1. ig

    What’s up to every , since I am genuinely keen of reading this web
    site’s post to be updated on a regular basis. It carries good material.

Comments are closed.