Oct 11 2022 01:36 AM
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
Oct 11 2022 01:58 AM
SolutionOct 11 2022 02:33 AM
Oct 11 2022 02:36 AM
Oct 11 2022 01:58 AM
Solutionin C1:
=MATCH("~~", A1:A8, 0)
in C2:
=MATCH("~*", A1:A8, 0)
in C3:
=MATCH("~?", A1:A8, 0)