find_in_range
Search a worksheet range or the entire used range for specified text, returning the first matching cell address or all matches as a combined address string.
Instructions
Find text in a range or the whole used range. Returns the address of the first match, or all matches as a (possibly multi-area) address string.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| all | No | Return all matches instead of only the first. Default true. | |
| text | Yes | Text to find. | |
| range | No | A1 range address to search. Defaults to the used range. | |
| matchCase | No | Case-sensitive search. Default false. | |
| sheetName | No | Worksheet name. Defaults to the active worksheet. | |
| workbookId | No | Target workbook ID from list_workbooks. Optional when only one workbook is connected. | |
| completeMatch | No | Match the entire cell contents. Default false. |