If cell contains part of a differnt cell range then enter the number

 

 

Hi,

 

 Could anyone figure out a formula for this?

 

If A2 contains all the text (not an exact match) from any cell from range B2 thorugh B50, then display the text that’s currently located in column C in that coresponding row. So if it finds that A2 contains text (not exact match) that exists say in B47 then it should display the text from C47 in column D2

 

Thanks

By: Jay

5 thoughts on “If cell contains part of a differnt cell range then enter the number

  1. ig

    Great blog here! Also your site loads up fast!
    What host are you using? Can I get your affiliate link to your host?

    I wish my site loaded up as quickly as yours lol

  2. Diego

    Magnificent beat ! I wish to apprentice at the same time as you amend your
    web site, how can i subscribe for a blog web site?
    The account aided me a acceptable deal. I had been a little bit
    acquainted of this your broadcast provided vivid transparent concept

  3. vurtilopmer

    What i don’t understood is in reality how you’re now not actually a lot more well-preferred than you might be now. You are so intelligent. You recognize therefore considerably when it comes to this topic, produced me individually imagine it from so many various angles. Its like men and women aren’t involved unless it’s something to accomplish with Woman gaga! Your individual stuffs great. All the time care for it up!

Comments are closed.