Hello Wizards of Excel,
I'm in a bit of a bind I'm trying to find a partial match within a list of keywords. I'm looking for the return result to be the word found in the list. I tried vloookup and index match, but the problem is that it only finds the exact match of the word and doesn't take into account any symbols or characters that maybe in front or in between the particular keyword I'm searching for. I even tried adding an "*" as a wildcard with the vlookup and index-match formuals, but it still didn't get the information I'm looking for. I provide a sample below of what I'm looking for. Any help shedding light on this would be appreciated.
-- corrupted image removed --
I'm in a bit of a bind I'm trying to find a partial match within a list of keywords. I'm looking for the return result to be the word found in the list. I tried vloookup and index match, but the problem is that it only finds the exact match of the word and doesn't take into account any symbols or characters that maybe in front or in between the particular keyword I'm searching for. I even tried adding an "*" as a wildcard with the vlookup and index-match formuals, but it still didn't get the information I'm looking for. I provide a sample below of what I'm looking for. Any help shedding light on this would be appreciated.
-- corrupted image removed --
Last edited by a moderator: