I have a sheet where column P has text like "Two Highways ~folk vinyl" (no quote marks).
the formula =MATCH(P2, P:P, 0) returns an #N/A error.
But removing the ~ has an odd effect:
with
Two Highways ~folk vinyl (in P2)
Two Highways folk vinyl (in P3)
=MATCH("Two Highways ~folk vinyl" ...