Forum Discussion
vlookup formula copy
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.
3 Replies
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
thank you for your response. yes, it was what i needed.SergeiBaklan
Lab_Rat , you are welcome
