# Get Row and Column

This is a pre-built Action located under the **@Excel Element**. The functionality of this Action in Avo Assure is to retrieve the row and column number that contains a specified value from an Excel sheet. The result is stored in a dynamic variable for further use during test execution.

## **Syntax**

**Input Value**: `<text>`

<table><thead><tr><th>Argument</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td>&#x3C;text><br>(Required)</td><td>Provide the text to retrieve the row number and column number that contain the given value.</td><td></td></tr></tbody></table>

**Output Value**: `<Dynamic Variable>;<Dynamic Variable>(Optional)`&#x20;

<table><thead><tr><th>Argument</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td>&#x3C;Dynamic Variable><br>(Required)</td><td>This dynamic variable stores the row and column number. </td><td></td></tr><tr><td>&#x3C;Dynamic Variable><br>(Optional)</td><td>This dynamic variable stores the status as <strong>True</strong> or <strong>False</strong>.</td><td></td></tr></tbody></table>

### **Example: Finding Specified Text and Retrieving its Cell Position**

In this example, we explain how to find a specified text in an Excel file and return its cell position using the **Get Row and Column** action.

* **Action**: Get Row and Column
* **Input Value**: Accountant
  * The input value (**Accountant**) specifies the text to be searched within the Excel sheet. The action searches for this text across the sheet and identifies the exact row and column coordinates where it is located.
* **Output Value**: {RowCol}
  * The row and column position (e.g., Text 'Accountant' found at row 4, column 3) is stores in the **{RowCol}** dynamic variable.
  * If a second output variable is defined, it stores the action status with the following possible values:
    * **True**: If the text is found and the position is returned successfully.
    * **False**: If the text is not found in the Excel sheet.
* **Logical Explanation**: The **Get Row and Column** action takes the value from the **Input Value** column **Accountant** and searches the configured Excel file for the specified text. It returns the row and column position where the text is found. The retrieved position is stored in the **{RowCol}** variable (e.g., Text 'Accountant' found at row 4, column 3).

<figure><img src="/files/gGVD8Ig5J42Ijq3RonMd" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.avoautomation.com/avo-assure/actions/excel/get-row-and-column.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.