Hi,
Currently wanted to develop the formula which enable to make lookup if partial string match exists.
For example I have a range of values
12345
67890
13579
And want match with value for example 12349
So basically it should mach with the first Value in the range, in other words make matching even there is one different value in the string.
For this case Vlookup and WILDCARDS can be used, but te issue sis that this different number can be in the beginning of the string or at the end, for example 91234 or 12349.
Bookmarks