Results 1 to 5 of 5

Forumla Doesn't Auto-Increment Correctly

Threaded View

  1. #1
    Registered User
    Join Date
    09-06-2022
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft 365
    Posts
    14

    Forumla Doesn't Auto-Increment Correctly

    Hi!

    My problem is...
    I have this formula in A1:

    =INDEX('Sheet1'!$L107,'Sheet2'!$L107,'Sheet3'!$L107)

    Then I have this in A2:

    =INDEX('Sheet1'!$L138,'Sheet2'!$L138,'Sheet3'!$L138)

    I want to be able to drag down the formula where it automatically fills in the next correct cell which happens to be exactly 31 cells apart.

    So the next formula in A3 should be:

    =INDEX('Sheet1'!$L169,'Sheet2'!$L169,'Sheet3'!$L169)

    But when I drag the formula down, it doesn't keep the correct tabulated formula. It generates the wrong one.

    How can I get it to automatically go down 31 cells when dragging down the formula?
    Last edited by coltonyyz; 12-18-2023 at 09:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 05-12-2018, 01:07 PM
  2. [SOLVED] forumla to check if cell doesn't contain certain characters
    By netimports in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2018, 12:46 AM
  3. Index forumla doesn't always find all data
    By jndipworm in forum Excel General
    Replies: 4
    Last Post: 02-22-2016, 02:15 PM
  4. Forumla to convert currency, but doesn't lose formula in cell
    By smallbizguy10 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-24-2014, 07:17 AM
  5. [SOLVED] Ami reading this forumla correctly?
    By tiggynook in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2014, 02:09 PM
  6. Increment count skips, when copying forumla
    By shinbet in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2010, 11:06 PM
  7. Replies: 2
    Last Post: 10-28-2009, 03:02 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1