IF statement or VLOOKUP?

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.

sample.xlsx12 KB

excel

Formulas and Functions

Lorenzo Kim
Nov 21, 2018
I think I got it.
pls see attached file.
thanks..

melissa-m(search).xlsx13 KB

Lorenzo Kim
Bronze Contributor
Nov 20, 2018
pls see attached file.
hope you can make something out of it.
thanks..
melissa-m(search).xlsx13 KB
- Melissa McDowell
  Copper Contributor
  Nov 21, 2018
  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?
  - Lorenzo Kim
    Bronze Contributor
    Nov 21, 2018
    I think I got it.
    pls see attached file.
    thanks..
    
    melissa-m(search).xlsx13 KB

Forum Discussion

IF statement or VLOOKUP?

Share

Resources