# Get a Row's Cell

### Overview

This procedure retrieves a cell in a specific row of a worksheet that matches a given value, regex, or column label.

### Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

<details>

<summary><code>get the row's cell</code></summary>

#### What does it do?

Retrieves the value of a cell from a row in an Excel worksheet.

#### Where does it go?

This phrase should be written on a **new line**.

#### Is it required?

✅ Yes — This phrase is **required**.

#### Does it require data?

✅ Yes — A reference to **the row** must be previously defined in the automation.

</details>

<details>

<summary><code>the value is "cell-value"</code></summary>

#### What does it do?

Specifies the value of the cell to be identified.

#### Where does it go?

Indented under `get the row's cell`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **cell-value** with the value to find *(text)*.

#### Example

```
the value is "0"
```

</details>

<details>

<summary><code>the regular expression is "regex-pattern"</code></summary>

#### What does it do?

Specifies a regular expression pattern to match for cell identification.

#### Where does it go?

Indented under `get the row's cell`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **regex-pattern** with the regular expression to match.

#### Example

```
the regular expression is "\\dBob\\d"
```

</details>

<details>

<summary><code>the column label is "X"</code></summary>

#### What does it do?

Specifies the name of the column that contains the target cell in the current row.

#### Where does it go?

Indented under `get the row's cell`.

#### Is it required?

❌ No — This phrase is **optional**.

#### Does it require data?

✅ Yes — Replace **X** with the column label to search for.

#### Example

```
the column label is "AB"
```

</details>

### Examples

#### 1. Get the Row's Cell by Value

```
get the row's cell
    the value is "0"
```

#### 2. Get the Row's Cell by Regular Expression

```
get the row's cell
    the regular expression is "\\dBob\\d"
```

#### 3. Get the Row's Cell by Column Label

```
get the row's cell
    the column label is "AB"
```