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