• 580K Members
• 5,087 Online
• 702K Conversations
SOLVED

Highlighted
New Contributor

# 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 list of english suffixes. How would I search Column B for a suffix of the word in Column A? This is the best I could come up with, and it only works on a few words, but I can't figure out why... =VLOOKUP(RIGHT(A2),\$B\$3:\$B\$561,1,0). I would really appreciate any help you can provide. Thank you

3 Replies
Highlighted

# Re: VLOOKUP that searches for suffixes to a word...

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
Highlighted
Solution

# Re: VLOOKUP that searches for suffixes to a word...

C2=IFERROR(LOOKUP(1,0/(COUNTIF(\$A2:\$A2,"*"&\$B\$2:\$B\$31)>0),\$B\$2:\$B\$31),"")

Highlighted

# Re: VLOOKUP that searches for suffixes to a word...

@Grass405 Thank you so much, that is perfect!

Related Conversations
Word 365 svg import problem
Goupil35000 in Office 365 on
0 Replies
Page numbers won't start at 1
jamieschwenger in Office for Mac on
4 Replies
Deleting Sections in Word for the Mac
Bob_Irvine in Office for Mac on
0 Replies
Protected Word forms for assignments
Kylie66 in Word on
0 Replies