Hi
I am having big trouble because the argument I use for the VALUE in the Match function seems to be in the wrong format.

The value is not a number I hardcoded, but a number resulting from a formula combining "IF...RIGHT...CELL..."

the result is = 9

Let's assume this result is in cell A1

if I now use MATCH(A1;7/8/9;0)
the results is NA
and my original 9 is showed (in the Match Arguments) like this: "9"
instead of the pure number 9.

Obviously if I hardcode 9 in A1, the match formula works properly becase I have now 9 instead of "9" in the VALUE argument

how to solve it??? is there any formula to convert my result in A1?

thanks in advance