How can I lookup test~~ value in an array? So my lookup value is test~~ and my array contains test~~, the match has to be exact.
Vlookup won't work as the tilde is used to identify wildcards (i actually am searching for a value that can contain ~ or ~~) so looking for a suggestion on a possible workaround. I could create another column and substitute that values but would like to avoid that if possible.
GM
Vlookup won't work as the tilde is used to identify wildcards (i actually am searching for a value that can contain ~ or ~~) so looking for a suggestion on a possible workaround. I could create another column and substitute that values but would like to avoid that if possible.
GM