Hi,
I have a pretty straightforward job, match a value on a table and retrieve a value with the index function.
but the data to match it's full of a wildcard ?,*;', etc so when I need to match exactly on the other table, it doesn't retrieve the wrong data.
I tried to put the tide in front of the * wildcard, but for some reason, it doesn't work.
what I need to do is to set the match command to see just plain text and not as wildcards.
Thank you.
I have a pretty straightforward job, match a value on a table and retrieve a value with the index function.
'°; '.; '<; '(; '+; '!; '&; ']; '$; '*; '); ';; '-; '/; 'À; 'Ç; ',; '%; '_; '>; '?; 'È; 'Ì; ':; '£; '§; ''; '=; '"; '[ |
but the data to match it's full of a wildcard ?,*;', etc so when I need to match exactly on the other table, it doesn't retrieve the wrong data.
I tried to put the tide in front of the * wildcard, but for some reason, it doesn't work.
what I need to do is to set the match command to see just plain text and not as wildcards.
Thank you.