Forum Discussion
Fill Handle Corrupts a VLOOKUP Function
I can get the VLOOKUP function to work fine if I enter it manually. However, I have a sheet with over 700 rows and I want to use the fill handle to copy and auto-increment the VLOOKUP function to...
To prevent a reference from changing you add a $ to the formula
=vlookup(J6,Sheet2!A$1:D$15,2,FALSE)
The $ infront of the numbers "locks" the rows
If you also want to lock the columns (so the formula doesn't change when you copy left / right) then put a $ infront of the letters also
=vlookup(J6,Sheet2!$A$1:$D$15,2,FALSE)