Forum Discussion
Solved
VLOOKUP that searches for suffixes to a word...
Hi, I really hope someone can help me with this. I've been searching for hours in multiple forums, but I can't find a solution to my problem. Column A is a list of english words. Column B is a li...
C2=IFERROR(LOOKUP(1,0/(COUNTIF($A2:$A2,"*"&$B$2:$B$31)>0),$B$2:$B$31),"")
