I have an array which contains a list of values, which I want to check if any of them appears in another cell.
let's say my array values are in A1:A4:
A1: 4.1
A2: 4.2
A3: 6.2
A4: 6.3
Now I basically want to search for each row I have the data in if one of the values of A1:A4 appears within another string.
The cell structure is something like test/domain/4.1/part1 (the location of the searched text is not fixed, can appear in different place).
In this case, since 4.1 appears in the string, it should return 4.1, if it can be found should return 'None.
Can someone help please?
let's say my array values are in A1:A4:
A1: 4.1
A2: 4.2
A3: 6.2
A4: 6.3
Now I basically want to search for each row I have the data in if one of the values of A1:A4 appears within another string.
The cell structure is something like test/domain/4.1/part1 (the location of the searched text is not fixed, can appear in different place).
In this case, since 4.1 appears in the string, it should return 4.1, if it can be found should return 'None.
Can someone help please?
