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),"")
Here's an example of what I'm looking for:
| Column A | Result | Column B | |
| abactinal | etidine | ||
| abactinally | ally | facient | |
| abaction | tion | faction | |
| abactor | fashion | ||
| abaculi | flation | ||
| abaculus | florous | ||
| abacus | glossia | ||
| abacuses | ibility | ||
| abada | iferous | ||
| abaddon | iformes | ||
| abadejo | igerous | ||
| abadengo | iridine | ||
| abadia | isation | ||
| abadite | kinesis | ||
| abaff | logical | ||
| abaft | malacia | ||
| abaisance | manship | ||
| abaised | meister | ||
| abaiser | morphic | ||
| abaisse | ography | ||
| abaissed | olidine | ||
| abaka | ologist | ||
| abakas | onychia | ||
| abalation | phrenia | ||
| abalienate | phyceae | ||
| abalienated | poiesis | ||
| abalienating | rrhagia | ||
| abalienation | rrhaphy | ||
| abalone | sterone | ||
| abalones | tion |