T
Tekhnikos
I have an Index and Match formula which is supposed to match a number
formatted as text. I keep getting #N/A in the match cell. If I choose the
"convert to number" selection in the error checking option, the formula
works. I have tried to change the property to numbers and still receive an
error. I have used this formula in the past without issue.
formatted as text. I keep getting #N/A in the match cell. If I choose the
"convert to number" selection in the error checking option, the formula
works. I have tried to change the property to numbers and still receive an
error. I have used this formula in the past without issue.