Excel: SEARCH, FIND & CHOOSE Functions

SEARCH

SEARCH function in Excel returns the location of one text string inside to another string. SEARCH returns the position of the first character of find_text inside within_text. If there is more than one occurrence of the search string, SEARCH returns the position of the first occurrence. It allows wildcards, and it is not case-sensitive. 

The arguments of SEARCH function:

• find_text - The text to find.
• within_text - The text to search within.
• start_num - Starting position in the text to search. 

It's optional argument & defaults to:

1. FIND: FIND function in excel returns the position (as a number) of one text string inside another text string. When the text is not found, FIND returns a #VALUE error. FIND does not support wildcards, and is always case-sensitive. It has similar arguments like SEARCH function.

2. CHOOSE: The Excel CHOOSE function returns a value from a list using a given position or index. The values provided to CHOOSE can include references. For example, =CHOOSE(2,"Sun","Mon","Tue") returns "Mon", since "Mon" is the 2nd value listed after the index number. The values provided to CHOOSE can be hard-coded constants or cell references. The first argument for the CHOOSE function is index_num. This is a number that refers to subsequent values by index or position. The next arguments, value1, value2, value3, etc. are the values from which to choose from. Choose can handle up to 254 values.