Not Able to retrieve Wildcard characters like ~, *, ? in Index formula

New Contributor

We have used '~" character in a cell and tried to reference and find it using Index Match function but it was showing a value error.


Help us out in the above and explain why its not able to be retrieved.



3 Replies
best response confirmed by Sandeep026 (New Contributor)



in C1:

=MATCH("~~", A1:A8, 0)

in C2:

=MATCH("~*", A1:A8, 0)

in C3:

=MATCH("~?", A1:A8, 0)


You're welcome & Thanks for providing feedback (can help those who search....)