> For the complete documentation index, see [llms.txt](https://docs.roboteasy.tech/studio-en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roboteasy.tech/studio-en/studio/objetos/excel/pesquisar-valor.md).

# Search for Value

Object for Excel data search

## Settings 

{% hint style="info" %}
This object depends on the "**New Excel"** or **"Open Excel"** object to work.
{% endhint %}

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MVM3r91dDqCXUUp13LJ%2F-MVMGnZ6rPstn2o-Xseh%2Fimage.png?alt=media\&token=867f3040-c17d-4cc6-ac7e-dc86a73f2f3a)

| Field                  | Descriptive                                                                          |
| ---------------------- | ------------------------------------------------------------------------------------ |
| Títle                  | Object Title                                                                         |
| Object Identifier Name | Singular object name for the Excel data search                                       |
| Select Main Object     | Option to select the Excel spreadsheet                                               |
| Text                   | Text to search for                                                                   |
| Search Type            | Option to select the type of the search ("Exactly" or "Containing" the text entered) |
| Minimum Column         | Minimum search range column (minimum value 1)                                        |
| Maximum Column         | Maximum search range column                                                          |
| Minimum Row            | Minimum search range row (minimum value 1)                                           |
| Maximum Row            | Maximum search range row                                                             |

## Example

To search for values in an Excel spreadsheet file you need to follow a few steps:

1 - Select the **"Open Excel"** object from the "**Excel**" menu and drag it to your working area.

* First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.

2 - Then select the object **"Search for Value**" from the **"Excel"** menu, inform a name for the object, select the main object, inform the text to search for and select the search type ("Exactly" or "Containing" the informed text) and ,lastly, inform the target columns and rows for the search.