Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

If a cell string contains "~", MATCH function cannot find the cell.

If a cell string contains "~", MATCH function cannot find the cell. If a lookup value contains "~", MATCH ignores it. It is the only char with such a behavior, and it's look like an error. Didn't find any documentation regarding that.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrey Minakov shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base