When i use the following formula

=MATCH(1,$A$24:$A$31,0) --- gives result "1" (correct)

But when i am trying to use

=MATCH(RIGHT(A35,1),$A$24:$A$31,0) --gives not available

where
=RIGHT(A35,1) -- gives 1


Cell Value of A35 is - 1_1
Please correct me.