Nov 20 2018 02:56 PM
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.
Any help would be much appreciated.
Nov 20 2018 03:59 PM
pls see attached file.
hope you can make something out of it.
thanks..
Nov 20 2018 04:13 PM
Hi Lorenzo,
Thank you so much. That is amazing. Is there any way to make it just leave it blank if it can't find anything matching in the 'instruments' sheet?
Nov 20 2018 04:28 PM
SolutionI think I got it.
pls see attached file.
thanks..
Dec 02 2018 02:23 PM
Hi Lorenzo,
I was wondering if you might be so kind as to have a look at another problem for me?
https://techcommunity.microsoft.com/t5/Excel/Delete-duplicates/td-p/293715
I'm not having much luck from anyone and you were amazing with my previous post.
Thanks again,
Melissa
Dec 02 2018 09:29 PM
Nov 20 2018 04:28 PM
Solution