Hi
I am really struggling with matching text strings across two datasets which use different terminology. I have used a vlookup (within an IF and ISNA), with wildcards to match certain text strings but this only works when the original text string is part of the second text string ie SoS is part of ABC SOS DEF, but most of the matches I need to make are as follows;
GHI SOS JKL as part of ABC SOS DEF
which means I need to match 3-4 contiguous letters within both text strings, without using macros
Any help would be most appreciated
Thanks
Any
I am really struggling with matching text strings across two datasets which use different terminology. I have used a vlookup (within an IF and ISNA), with wildcards to match certain text strings but this only works when the original text string is part of the second text string ie SoS is part of ABC SOS DEF, but most of the matches I need to make are as follows;
GHI SOS JKL as part of ABC SOS DEF
which means I need to match 3-4 contiguous letters within both text strings, without using macros
Any help would be most appreciated
Thanks
Any