Excel: Find patterns in data points

Hello, I wonder if there is a way to check for a certain pattern in a list of data points. This image might clarify what I am looking for. I need a way to check if the pattern exists (and where) in the data points. [IMG]http://s1.postimg.org/ujsz4vh33/excelproblem.jpg[/IMG] I have tried with vlookup but only got it to work with finding 1 number.

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of November 23, 2014.

For more resources for Microsoft Excel