+ Reply to Thread
Results 1 to 4 of 4

Is there a way to make formulas follow cells?

  1. 03-05-2015, 11:02 PM #1
    mikey42979
    mikey42979 is offline
    Forum Contributor
    Join Date
    04-26-2013
    Location
    Orlando
    MS-Off Ver
    Excel 2016
    Posts
    191

    Is there a way to make formulas follow cells?

    I have a web query that runs each week and each week the query ads more data in various rows, my issue is that when using vlookup or any formula that references a table array the array might shift down a row or two. How can I lock the formulas to the array no matter if the array shifts position?
    Reply With QuoteRegister To Reply
  2. 03-05-2015, 11:05 PM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Is there a way to make formulas follow cells?

    Hi mikey,

    I think you are asking for Dynamic Named Ranges that grow as your data grows. They you base your VLookup function on this Name instead of a static range. See:
    http://www.bettersolutions.com/excel...G820716330.htm or
    http://www.ozgrid.com/Excel/DynamicRanges.htm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 03-05-2015, 11:12 PM #3
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Is there a way to make formulas follow cells?

    See this...

    http://www.contextures.com/xlNames01.html#Dynamic
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  4. 03-05-2015, 11:16 PM #4
    mikey42979
    mikey42979 is offline
    Forum Contributor
    Join Date
    04-26-2013
    Location
    Orlando
    MS-Off Ver
    Excel 2016
    Posts
    191

    Re: Is there a way to make formulas follow cells?

    Thanks a bunch guys ill look into this now.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to make "insert copied cells" automatically follow a formula without having to update?
    By dbwoods11 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2013, 02:15 AM
  2. make content follow a hyperlink
    By ltjohnson in forum Excel General
    Replies: 0
    Last Post: 06-12-2012, 08:58 PM
  3. VLOOKUP - How to make cell format follow?
    By Mr. Green Genes in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2009, 03:13 AM
  4. Only follow formulas with values???
    By StevieP in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2007, 12:56 PM
  5. [SOLVED] How do I make a row or information, follow as you scroll down..?
    By Dave_86 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2005, 11:06 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1