Forum Discussion

Copper Contributor

Nov 20, 2018

Solved

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

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

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

Melissa McDowell
Copper Contributor
Nov 21, 2018
Amazing. I can't thank you enough.
- Lorenzo Kim
  Bronze Contributor
  Nov 21, 2018
  Glad to be of help..
  - Melissa McDowell
    Copper Contributor
    Dec 02, 2018
    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