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

[Sandeep026]

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.

Thanks

[#2 · Accepted solution]

@Sandeep026 

in C1:

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

in C2:

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

in C3:

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

[#3]

Thanks!

[#4]

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