Results 1 to 3 of 3

Thread: Changing part of formula/leaving other parts intact

  1. #1
    New Member
    Join Date
    Oct 2018
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Changing part of formula/leaving other parts intact

    Hello

    I need to drag this formula down several cells however when I do itchanges the values by 1.

    =VLOOKUP(A25,$A1:$I20,5,FALSE)


    How do I keep the formula “$A1:I20,5,FALSE”intact but change A25 to be A26, A27, A28, etc.,?

    Thank you.


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    North Yorkshire, UK
    Posts
    263
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Changing part of formula/leaving other parts intact

    You need to make the lookup area completely absolute by putting $ in front of both the column letter and row number like this:

    =VLOOKUP(A25,$A$1:$I$20,5,FALSE)
    It's curtains for your Dr. Horrible ... lacy, gently wafting curtains.

  3. #3
    New Member
    Join Date
    Oct 2018
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Changing part of formula/leaving other parts intact

    Thank you!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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