|
|
#1
06-29-2011, 08:21 AM
|
|||
|
|||
Search Function Problem
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. 
|
|
#2
06-29-2011, 08:27 AM
|
|||
|
|||
|
No, the result should not be 1.
=SEARCH("fire","fireman") should be 1. The frist argument is what you want Excel to find. The second argument is where you want Excel to look. There is no "fireman" in "fire".
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Windows explorer search problem...help!!
|
NewSysAdmin | Windows | 1 | 03-08-2011 05:33 PM |
| if function help | jim831 | Excel | 2 | 10-29-2010 07:06 PM |
| Search and Replace - Clear Search box | JostClan | Word | 1 | 05-04-2010 08:46 PM |
|
Is this possible using the Vlookup or any other function?
|
Delson | Excel | 4 | 02-08-2010 01:27 PM |
|
Need help on what function to use???
|
Primeraman | Excel | 1 | 06-13-2006 10:16 AM |
Mac OS X 
Office 2008 for Mac
Linear Mode
