FIND formula help needed
Where did she state that she searched columns?
--
Regards,
Peo Sjoblom
"JLGWhiz" wrote in message
...
You are using the wrong function for what you are trying to do. The FIND
function is to find a string within a string, not to search columns.
"Carole O" wrote:
Excel 2000
The formula =IF((FIND("Overall",B2)),"Y","N") produces a Y if the word
Overall appears in column B, but instead of an N if it doesn't, a #VALUE!
appears. I've tried "", false and leaving it out - but the #VALUE!
always
appears.
Any ideas?
CaroleO
|