Increase Row reference when using Index

**darknation144** · 02-20-2012, 10:46 AM

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

**Bmoe** · 02-20-2012, 10:52 AM

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.

**darknation144** · 02-20-2012, 11:45 AM

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

**Bmoe** · 02-20-2012, 01:07 PM

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

**darknation144** · 02-21-2012, 06:04 AM

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.

**Bmoe** · 02-21-2012, 07:24 AM

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.

**darknation144** · 02-23-2012, 07:09 AM

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.