> For the complete documentation index, see [llms.txt](https://docs.avoautomation.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.avoautomation.com/avo-assure/actions/excel/get-row-and-column.md).

# 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)`

<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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.