MATCH problem
The tilde is causing the problem. I'm guessing because its a type of wildcard
character.
Possible workarounds: Depending on what your doing, maybe using FIND,
LOOKUP, or VLOOKUP?
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Smallweed" wrote:
Hi - can anyone tell me why I get #NA when I try to match a cell with contents:
AWDAXJ$(RI#S)~£
with another cell with exactly the same entry?
And is there a workaround?
Thanks
|