Hi guys,
I am trying to write a function that is able to take any character contained in my original cell (which is filled with a text string) and see if it exists on my destination / lookup cell.
So far i made some attempts, one of which included the use of a wildcard (don't know the first thing about wildcards, so i may be using it incorrectly)
It was something of the sort:
=ISNUMBER(SEARCH("["& original cell & "]";within lookup cell)
An example to make my explanation a bit less confuse.
Let's say i have a cell with the text "abcdefg". I want the function to search any of these characters- a, b, c, d, e, f, g - against my lookup cell, which has the text "a". Given that "a" is one of the characters of "abcdefg" the ideal function would return 1. I do not need to know the position of the character, i am only interested in knowing if at least one of the characters exists.
A regular search function returns #VALUE since "abcdefg" is not written anywhere on my lookup cell, which only has "a", thus it cannot be found.
Thanks!