I have a list of numbers in a random set sequence from A2:A165000. In D1 I have my target number as a column heading: 2588. In this column I would like to generate a list all of the numbers that occur directly before my target. And in E1 a list of the numbers that occur directly after my target.

I am able to find a single instance with the following formulae:

```
=INDEX(A2:A165000,MATCH(2588,A2:A165000,0)-1)
=INDEX(A2:A165000,MATCH(2588,A2:A165000,0)+1)
```

How do I expand this to find all of the other instances?