Forum Discussion
KMorrison5151
Mar 17, 2020Copper Contributor
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 anyone suggest the function for that request? Thank you!
9 Replies
- PReaganBronze Contributor
- KMorrison5151Copper Contributor
Many thank yous! Works perfectly.
- PReaganBronze Contributor