Mar 17 2020 05:53 AM
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!
Mar 17 2020 06:12 AM
SolutionMar 17 2020 07:46 AM
May I ask you one more...I have codes in column a. I want to test those codes against a table and return a results based on that table. Any thoughts on the function to use? In my file below, in column b - if a2 contains "PS01" then "Valid" else if a2 contains "PE11" then "Disconnected" else N/A. Thank you!!
Mar 17 2020 09:52 AM
Hello @KMorrison5151,
For Valid/Disconnected, that could be:
=IFERROR(IF(SEARCH($E$2,$A3),$F$2),"")&
IFERROR(IF(SEARCH($E$3,$A3),$F$3),"")
For Land/Cell/VOIP, that could be:
=IFERROR(IF(SEARCH($E$6,$A2),$F$6),"")&
IFERROR(IF(SEARCH($E$7,$A2),$F$7),"")&
IFERROR(IF(SEARCH($E$8,$A2),$F$8),"")
Mar 17 2020 10:02 AM
Again, thank you! You make it look so easy. I am humbled.
Jul 08 2021 06:52 AM
@PReagan, would it be possible to do the "if then data" on another worksheet?
Jul 09 2021 10:16 AM
Absolutely! Simply adjust your cell references to the cells on the other sheet. For example, =Sheet2!A1
Mar 17 2020 06:12 AM
Solution