Equivalent to clicking the Find command on the Edit menu. Selects the next or previous cell containing the specified text and returns TRUE. If a matching cell is not found, FORMULA.FIND returns FALSE and displays a message.
Syntax
FORMULA.FIND(text, in_num, at_num, by_num, dir_num, match_case)
FORMULA.FIND?(text, in_num, at_num, by_num, dir_num, match_case)
Text is the text you want to find. Text corresponds to the Find What box in the Find dialog box.
In_num is a number from 1 to 3 specifying where to search.
| In_num | Searches |
| 1 | Formulas |
| 2 | Values |
| 3 | Notes |
At_num is the number 1 or 2 and specifies whether to find cells containing only text or also cells containing text within a longer string of characters.
| At_num | Searches for text as |
| 1 | A whole string (the only value in the cell) |
| 2 | Either a whole string or part of a longer string |
By_num is the number 1 or 2 and specifies whether to search by rows or by columns.
| By_num | Searches by |
| 1 | Rows |
| 2 | Columns |
Dir_num is the number 1 or 2 and specifies whether to search for the next or previous occurrence of text.
| Dir_num | Searches for |
| 1 or omitted | The next occurrence of text |
| 2 | The previous occurrence of text |
Match_case is a logical value corresponding to the Match Case check box in the Find dialog box. If match_case is TRUE, Microsoft Excel matches characters exactly, including uppercase and lowercase; if FALSE or omitted, matching is not case-sensitive.
Remarks
In Microsoft Excel for Windows, the dialog-box form of FORMULA.FIND is equivalent to pressing SHIFT+F5.
If more than one cell is selected when you use FORMULA.FIND, Microsoft Excel searches only that selection.
Return to index