What I want it to do is search the 'instruments' sheet to see if any of those words come up in the titles on the titles sheet in column 1. I then want it to display that instrument in column D of the titles page.
I've just done a tiny version as the actual file is over 100k products.
thank you for the trust.. I viewed your query but sorry to say I can not concentrate on the task at hand as I am attending to my brother's passing away recently. We are all in a mess and I can not say when I can return to the forum. thank you very much and good luck..