vlookup formula copy

[Lab_Rat]

I want to copy a vlookup formula to more cells by dragging.  I was told there is a way to lock the formula so it does not change.  VLOOKUP(C2,V2:W16,2,FALSE) the V2:W16.  I want the same formula on consecutive cells in a column.

[#2]

@Lab_Rat 

If you would like to fix the range use absolute references (with $)

=VLOOKUP(C2,$V$2:$W$16,2,FALSE)

If to fix C2, when $C$2 instead

[#3]

thank you for your response.  yes, it was what i needed.@Sergei Baklan 

[#4]

@Lab_Rat , you are welcome