Lookup question

[happyhungarian]

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

 

[Jonmo1]

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]

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]

Perhaps

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

 

[happyhungarian]

Thanks again! Worked great

 

[Jonmo1]

Glad to help, thanks for the feedback.