PDA

View Full Version : Search Function Problem



fjhsui
07-01-2011, 08:36 PM
I enter the following into a cell:
=SEARCH("fireman","fire")
and the result is #VALUE!.

Why does this happen? Shouldn't the result be 1?

The only time this function seems to work is when I type in:
=SEARCH("fire","fire")
The result in this case is 1.

I am using Mac Office 2008.

GTO
07-01-2011, 08:44 PM
I believe you have it reversed.

=SEARCH("fire","fireman")

shrivallabha
07-02-2011, 12:12 AM
If the formatting is consistent then following will work as well:

=SEARCH(LEFT("fireman",4),"fire")