Hello!

I have a worksheet where column B has a list of serial numbers like X130V440B002. In column E, there's similar numbers like D230Y588B1003. I have used VLOOKUP to find which numbers have a perfect match. They are printed in the column C. The actual problem is that I also have to find numbers which are partially matched. In the column E the last three numbers are rolling numbers so there could many partial matches like X130V440B002 in column B and X130V44B055 and X130V44B026 in column E. So I would need a function which can find if there's a serial number in the column E where the first 8 digits match with the original (column B). I don't know if it's possible to make a function that can print all the matches somehow but even function that can tell that there's a 8 digit match in the column E list would be helpful.

Thanks for your help!