Forum Discussion

KMorrison5151's avatar
KMorrison5151
Copper Contributor
Mar 17, 2020
Solved

Cell contains partial text match

I have two columns of data. I would like a fuzzy match from B2 to A2. So if value from b2 is anywhere in a2 that is a match. In attached spreadsheet the result would be No, No, Yes, No, Yes etc. Can ...
excel
  • PReagan's avatar
    PReagan
    Mar 17, 2020

    Hello KMorrison5151,

     

    Starting in cell C2:

    =IFERROR(IF(SEARCH(B2,A2)>0,"YES"),"NO")
Chant711's avatar
Chant711
Copper Contributor
Jul 08, 2021

PReagan, would it be possible to do the "if then data" on another worksheet?

PReagan's avatar
PReagan
Bronze Contributor
Jul 09, 2021

Chant711 

 

Absolutely! Simply adjust your cell references to the cells on the other sheet. For example, =Sheet2!A1

Resources