Hi!

I just want to ask how can I use VLOOKUP() to look a match range to another range but instead of it looking for the EXACT values, I want to look for "LIKE" values. Example:

Column A
FIRE
ICE
WIND
WATER

Column B
FIRE WORKS
ICE BERG
WIND VANE
WATER BASE

As you can see, if I use VLOOKUP() in here it wouldn't find any match. What I want is to do is look up Column A to Column B and find matches if their values are similar to each other.


Thank you.