Results 1 to 3 of 3

Thread: copying cells down the page

  1. #1

    copying cells down the page



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to copy this formula down the page but want the highlighted cell to stay the same how do I go about it =VLOOKUP(A3,'Season '!$B:$AF,MATCH($B1,'Season '!$B$1:$AF$1,0),0) At the moment it changes to the cell I put it in how do I go about stopping it changing ???

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Just add a $ between the B and 1

    =VLOOKUP(A3,'Season '!$B:$AF,MATCH($B$1,'Season '!$B$1:$AF$1,0),0)

    The $ "freezes" the column and/or row it is place in front of. This is called Absolute referencing.


  3. #3
    Thank you very much that will save some time

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •