+ Reply to Thread
Results 1 to 2 of 2

auto increase row number with index match

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    2010
    Posts
    292

    auto increase row number with index match

    I am using index match to point to a particular cell on a page. When I copy the formula down however it is just copying the base formula and not automatically pointing to the next row down. I have like 150 cells to reference and changing the row number for each formula will be a pain. Is there a way to automatically add 1 to the row number when copying an index match formula down?

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,967

    Re: auto increase row number with index match

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. INDEX MATCH MATCH will not auto populate and takes LONG
    By njm0059 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2018, 04:32 AM
  2. [SOLVED] vba to auto increase an ID number
    By rob_h in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2017, 03:28 AM
  3. Increase criteria for {=INDEX(A:A,MATCH(LARGE(IF(B:B=52,C:C),1),C:C,0))}
    By albanhac in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-14-2016, 07:31 PM
  4. [SOLVED] Auto increase quote number
    By supremelighting in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2016, 12:30 PM
  5. [SOLVED] Converting Hlookup to Index Match with variable column index number
    By SimonLock in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-09-2015, 09:14 AM
  6. [SOLVED] Counting the number of times INDEX/MATCH finds more than 1 match.
    By loloduane in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-23-2014, 03:35 AM
  7. Auto increase number and save as macro
    By SPet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2013, 01:07 PM

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