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