SOLVED
Home

IF statement or VLOOKUP?

Highlighted
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.

thanks..

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?

Solution

I think I got it.

pls see attached file.

thanks..

 

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?

 

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

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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies