+ Reply to Thread
Results 1 to 7 of 7

Increase Row reference when using Index

  1. #1
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    552

    Increase Row reference when using Index

    Hi I have an order form that uses index for find a title and then needs to show all the values below a given title E.G Quantity. I can get it to work but I was wondering if there is an easy way to increase the row reference.

    So I have =INDEX('Paste Area'!F:F,(MATCH($A$8,'Paste Area'!F:F,0)+2)) I want it so when I drag the formula down the +2 will become +3 then +4 and so on.

    Thanks for any help.

    Orders.xlsx
    Last edited by darknation144; 02-23-2012 at 07:09 AM.

  2. #2
    Registered User
    Join Date
    04-19-2010
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Increase Row reference when using Index

    There might be a way, but you could use a helper cell that has the numbers in it or use +ROW() if they line up that way where row2 is +2.
    Excel\Access, VBA, C#, C++, SQL, Java

  3. #3
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    552

    Re: Increase Row reference when using Index

    As they won't necessarily line up it would be nicer to have a formula that does the same if it is possible.

  4. #4
    Registered User
    Join Date
    04-19-2010
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Increase Row reference when using Index

    Are the offsets uniform? Can you do Row()+2 or Row()-1. I can't really figure out what you want to do in the example

  5. #5
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    552

    Re: Increase Row reference when using Index

    The offsets are uniform. For every cell down the row needs to increase by 1. It works by me manually changing the number but I just wondered if there is a way to get excel to increase the number.
    Last edited by darknation144; 02-21-2012 at 06:17 AM.

  6. #6
    Registered User
    Join Date
    04-19-2010
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2007
    Posts
    93

    Re: Increase Row reference when using Index

    If they are then you should be able to do ROW() + 1

    so in R2 you will get ROW() = 2 + 1 = 3, R3 ROW() = 3 +1 = 4 and so on.

  7. #7
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    552

    Re: Increase Row reference when using Index

    You still can't do that. I've entered 3 formulas as you can see if you drag them down they don't increase. In the end I used a helper column and hid it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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