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.
Bookmarks