Hi everyone,

I have a tricky problem and have not been able to find a good solution.

I have one spreadsheet called Search which basically has Column A listing different part numbers, which can have any kind of format (AA-DD, CCC-DD, etc). In Column B I just need a function which will search the part numbers in strings of text in multiple workbooks.

The multiple workbooks are excel files sent by suppliers, and can be in different formats. I will put this in one folder. Part numbers can be in a cell with descriptions, and therefore the search must look through all text in all populated cells.
If it finds the part number then it should return TRUE/FALSE into Column B of the Search sheet.

As you can see this is actually the FIND function of Excel. However to use this one has to manually search each part number.

Would anyone happen to have any nice solution? I would actually prefer a function but it seems like VBA is needed for this.

I have done some VBA but am still a beginner.

Thanks!