In Excel, how could we extract the content from a specified row and column? There is a formula with INDIRECT and ADDRESS functions in Excel. By applying it to the worksheet, we can easily extract the content of the specified row and column.

For instance, you need to find the cell value based on the location. In this case, we can use that formula. In this tutorial, we will show the simple formula used to **get the content of the given row and column in Excel**. Get an official version of** MS Excel** from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Jump To

## General Formula

Here we come up with a simple formula to get the **content of the given row and column in Excel**.

**=INDIRECT(ADDRESS(row, column))**

## Syntax Explanations

**INDIRECT**– The**INDIRECT Function**in Excel returns a valid reference from a given text string.**ADDRESS**– The**ADDRESS function**will help to create a cell address from a given row and column.**Comma symbol (,)**– It is a separator that helps to separate a list of values.**Parenthesis ()**– The main purpose of this symbol is to group the elements.**Row**– It represents the row number in your worksheet.**Column**– It contains the column number from the input data.

## How to Apply Formula to Get Content of Specified Row & Column?

In order to extract the content of a specified cell from the range, we can use an Excel formula. This formula can make use of the INDIRECT and ADDRESS functions. The **INDIRECT function** will help you get the **reference of a cell**, whereas, **ADDRESS function** can return the text string that represents the **address of a cell** or a range of cells. For instance, we will need to get the content of the cell which has the **total score gotten by Edward** in his examination.

**Use **the **below-mentioned formula** in any cell where you want to get the output result.

**=INDIRECT(ADDRESS(H1,H2))**

Once you have entered the formula, **click **on the **Enter **button to execute it and get the result.

If the above-given scenario is not enough to understand this formula and want to learn this with a simple example, kindly move to the following section.

## Alternate Example

Here we come up with a simple example to know how to apply this Excel formula in the spreadsheet.

- In the below example image, you can see the
**list of fruits and their sales prices**based on the month. And we want to get**how many Kg of grapes sold on****Mar 05, 2023**.

- Then,
**enter the given formula**in a cell where you want to get the result.

**=INDIRECT(ADDRESS(G1, G2))**

- Finally, you will need to
**click**the**Enter**button to get the result, as shown in the below screenshot.

From this example, you can easily understand how to get the value given in the specified row and column.

## Closure

Hope you understood the formulas used to **get the content of the given row and column in Excel**. If you have any **doubt** regarding this article or have any other **questions** related to Excel, let me know in the **comments** section below. Click here to know more about **AawExcel **and **Excel Formulas****!! **Thank you so much for visiting our site!!

## Video Tutorial

The following video will let you know how to use an Excel formula to get the content or value of the given row and column in the worksheet.

**Read Ahead:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?

**Deepak** is an Excel enthusiast and data analyst with over **5 years** of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!