Forum Discussion

Lab_Rat's avatar
Lab_Rat
Copper Contributor
May 12, 2022

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 c...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 12, 2022

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

  • Lab_Rat's avatar
    Lab_Rat
    Copper Contributor
    Mar 30, 2023

    thank you for your response.  yes, it was what i needed.SergeiBaklan 

Resources