# Excel formula that assists in looking for sequence

#### brian8989

##### New Member
https://imgur.com/a/5HUdECj

Dear Experts,

With reference to the attached table, is there any excel formula that could assist to find the 10th number after Number 1 in Column A (which is 14).

I would greatly appreciate if you could assist on this. Thank you!

Regards,
Brian

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
=OFFSET(A8, 10, 0) would return the 10th row after the 1 on column A

Excel 2013/2016
ABCDEFGHIJKL
118105374629
2311518141348196216
310241420813166181912
473
554
6115
7176
817
9158
1029
11410
121911
131312
14613
15814
161815
171616
181417
191218
202019
21920
Template
Cell Formulas
RangeFormula
C2=INDEX(\$A\$2:\$A\$21,MATCH(\$B2,\$A\$2:\$A\$21,0)+C\$1)

Thank you so so so so much for helping! @Fluff

@Is there any formula to make it restarts from Number 3 in Column A in order to avoid reference error problem?

https://imgur.com/a/VMckQ4H

Thank you!

=INDEX(\$A\$2:\$A\$21,IF(MATCH(\$B2,\$A\$2:\$A\$21,0)+C\$1>ROW(\$A\$21)-1,MATCH(\$B2,\$A\$2:\$A\$21,0)+C\$1-ROW(\$A\$21)+1,MATCH(\$B2,\$A\$2:\$A\$21,0)+C\$1))

@Fluff It works!!! Thank you so so so so much!!!!

You're welcome & thanks for the feedback

Replies
1
Views
178
Replies
8
Views
300
Replies
4
Views
193
Replies
1
Views
220
Replies
11
Views
362

1,219,812
Messages
6,150,368
Members
450,956
Latest member
Alan361

### 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