SOLVED

IF statement or VLOOKUP?

Copper 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?

best response confirmed by Melissa McDowell (Copper Contributor)
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..
1 best response

Accepted Solutions
best response confirmed by Melissa McDowell (Copper Contributor)
Solution

I think I got it.

pls see attached file.

thanks..

 

View solution in original post