LinkBack URL
About LinkBacks
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.
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.
try
=MATCH(RIGHT(A35,1)+0,$A$24:$A$31,0)
RIGHT(A35,1) or just RIGHT(A35) is a text number you can make it into a real number by any of
RIGHT(A35,1)+0
RIGHT(A35,1)*1
--RIGHT(A35,1)
Last edited by martindwilson; 05-16-2013 at 08:57 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi,
your formula will be:
=MATCH(--RIGHT(A35,1),$A$24:$A$31,0)
--RIGHT(A35,1) is a value, is not a text.
@@@martindwilson
WOW!! Many Thanks!
Can you please let me know why is that 0 added at the end?
see post #2
Many Thanks. I have been struggling for this since 3 hrs.Originally Posted by martindwilson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks