Search fuction

%3CLINGO-SUB%20id%3D%22lingo-sub-1188269%22%20slang%3D%22en-US%22%3ESearch%20fuction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1188269%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20excel%20is%20ignoring%20the%20third%20argument%20of%20the%20SEARCH%20function%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSEARCH%20(find%20text%2C%20within_text%2C%20start%20number)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20ignores%20the%20start%20number%20argument..%26nbsp%3B%3C%2FP%3E%3CP%3EEx.%20in%20EXAMPLE%2C%20if%20I%20ask%20to%20search%20%22P%22%20beginning%20in%203%20(or%20A)%2C%20it%20returns%205%20(it%20should%20return%202)..%20Does%20anyone%20know%20how%20to%20solve%20it%3F%3F%20Is%20it%20a%20configuration%20issue%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1188269%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1188278%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20fuction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1188278%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F477943%22%20target%3D%22_blank%22%3E%40Alvaro1990%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20correct%20behavior.%20SEARCH%20starts%20looking%20for%20P%20from%203rd%20position%20and%20returns%20absolute%20position%20of%20the%20found%20text%20within%20string.%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%26nbsp%3B%3CSTRONG%3EE%3CFONT%20color%3D%22%23FF0000%22%3EP%3C%2FFONT%3EAMPLE%3C%2FSTRONG%3E%2C%20with%20your%20sample%20SEARCH%20returns%205%20as%20well.%20However%2C%20if%20you%20take%201%20as%20start%20number%20it%20returns%202.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, 

 

My excel is ignoring the third argument of the SEARCH function

 

=SEARCH (find text, within_text, start number)

 

It ignores the start number argument.. 

Ex. in EXAMPLE, if I ask to search "P" beginning in 3 (or A), it returns 5 (it should return 2).. Does anyone know how to solve it?? Is it a configuration issue??

 

Thanks!

1 Reply
Highlighted

@Alvaro1990 

It's correct behavior. SEARCH starts looking for P from 3rd position and returns absolute position of the found text within string. 

Try EPAMPLE, with your sample SEARCH returns 5 as well. However, if you take 1 as start number it returns 2.