Forum Discussion
When =if(snumber(search is not enough
Hi I would like to find an exact match of a grape within a product name of different wines. The problem is that there are so many blends that if I use =if(isnumber(search or =if(isnumber(find th...
Anna,
| B3 | {=IFERROR(INDEX($F$3:$F$16,MATCH(AGGREGATE(14,6,$G$3:$G$16/COUNTIFS(A3,"*"&$E$3:$E$16&"*"),1),$G$3:$G$16/COUNTIFS(A3,"*"&$E$3:$E$16&"*"),0)),"Other")} |
| G3 | =LEN(E3) |
In some cases there are multiple matches. The formula uses the match with the longest text.
But there are still some differences to your desired outcome.