IF statement or VLOOKUP?

Melissa McDowell
Occasional Contributor

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.

7 Replies

pls see attached file.

hope you can make something out of it.


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?


I think I got it.

pls see attached file.



Amazing. I can't thank you enough.

Glad to be of help..

Hi Lorenzo,


I was wondering if you might be so kind as to have a look at another problem for me?


I'm not having much luck from anyone and you were amazing with my previous post.

Thanks again,



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..
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
11 Replies