Hi Gurus,



I have a sheet with a long column with several thousand numbers in the rows. I need to search through this entire column and find a specific pattern of contingent numbers if it exists.

Example: column B1:B5678 contains many entries in the rows containing numbers. I'd like to enter something like in cells C1:C3 the numbers 15, 39 and 54. The formula or VBA would look through B1:B5678 and see if numbers 15, 39 and 54 are in contingent cells in this column and if so, tell me where.

I've explored the MATCH, FIND and SEARCH functions but they are typically looking for a single value while I'm looking for 3 values together in contingent cells.

Any ideas? Thanks!!