SOLVED

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.

 

Thanks

3 Replies
best response confirmed by Sandeep026 (New Contributor)
Solution

@Sandeep026 

_Screenshot.png

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....)