cell reference syntax clues?

Posted by laura jean on February 06, 2002 7:01 AM

so, I would like to look among cells F69:F72 for
the one with an "=", and get the contents of that
cell:

=F(69+MATCH("*=*",F69:F72,0)-1)

(that was a wild guess at the syntax, not suprisingly,
WRONGO!)

Posted by jean laura on February 06, 2002 11:07 AM

good question, laura!

why don't you try:

INDEX(A90:K90,MATCH("*=*",A90:K90,0))

then you can extract the value to the right of
the "=" with:

=RIGHT(INDEX(A90:K90,MATCH("*=*",A90:K90,0)),LEN(INDEX(A90:K90,MATCH("*=*",A90:K90,0)))-FIND("=",INDEX(A90:K90,MATCH("*=*",A90:K90,0))))+0

good luck!