# Lookup question

#### happyhungarian

##### Board Regular
I was wondering if there is a way to have a vlookup (or some other formula) to take information from a row that's X number of rows away from the value you're looking up. Example: my data source spits out information in the following format (all of this would be in column A for example):

Customer 1
Cumulative
Incremental
Customer 2
Cumulative
Incremental

If I want to do a vlookup for Customer 2's Incremental data is there a way to have the formula find "Customer 2" but then take the information from 2 rows after? Obviously I can't just vlookup "incremental" because it would take Customer 1's data. I thought about adding a second column with just the "Customer 2" portion repeating down the side and then using the Sumproduct formula to do a 2-criteria lookup but I really need to avoid adding a second column.

Thanks for the help as always

Jesse

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### Jonmo1

##### MrExcel MVP
You can use

=INDEX(A:A,MATCH("Customer 1",A:A,0)+X)

make the X 1 to get cumulative, 2 to get Incremental

#### happyhungarian

##### Board Regular
Thanks! Now if I wanted to use this over a period of time (say for 12 months with the incremental and the cumulative data starting in column b {but the "Customer 2","Cumulative", "Incremental" labels still in column a}) how would i adjust the formula?

#### Jonmo1

##### MrExcel MVP
Perhaps

=INDEX(B:B,MATCH("Customer 1",A:A,0)+X) ?

#### happyhungarian

##### Board Regular
Thanks again! Worked great

#### Jonmo1

##### MrExcel MVP
Glad to help, thanks for the feedback.

Replies
3
Views
159
Replies
8
Views
674
Replies
10
Views
266
Replies
1
Views
141
Replies
3
Views
140

1,195,669
Messages
6,011,059
Members
441,580
Latest member
BornholmerBjarne

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back