I have no idea what FINDROW is, but it looks to return a cell value, whereas
COUNTIF wants the cell reference. So it won't work. As FINDROW seems to be a
UDF, maybe you could change it to do it all.
--
HTH
Bob Phillips
"JemyM" wrote in
message ...
Thanks both of you for your reply...
I am using FINDROW to detect the cell that need to be compared with.
A36 contains the word "Dancer"
$A$542:$I$564 is the field where all data exist. First column contains
the profession, and the 9th column from that contains the skills.
When I type:
=FINDROW($A$36;$A$542:$I$564;9)
in cell J551, then I get the skills, such as Dance etc, listed in that
cell. That works.
If I use
=IF(COUNTIF(J551;"*Dancer*");"Is a Dancer";"Is not a Dancer")
then I get "Is a Dancer.
So far everything works.
However, when I try to replace J551 with the FINDROW line I am met with
an error:
=IF(COUNTIF(FINDROW($A$36;$A$542:$I$564;9);"*Dance r*");"Is a
Dancer";"Is not a Dancer")
I only get "Error in formula" and Excel refuses to accept it. :(
--
JemyM
------------------------------------------------------------------------
JemyM's Profile:
http://www.excelforum.com/member.php...o&userid=26945
View this thread: http://www.excelforum.com/showthread...hreadid=467251