=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