# Increase Row reference when using Index

1. ## 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  Register To Reply

2. ## 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.  Register To Reply

3. ## 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.  Register To Reply

4. ## 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  Register To Reply

5. ## 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.  Register To Reply

6. ## 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.  Register To Reply

7. ## 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.  Register To Reply