Skip to content

Formulas to Get Content of Given Row & Column in Excel!

Listen to this article

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:

Formula to get content of given row and columnPin
Formula to get content of given row and column

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.

Student's Score BoardPin
Student’s Score Board

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


Enter the formulaPin
Enter the formula

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.
Fruits Sales DetailsPin
Fruits Sales Details
  • Then, enter the given formula in a cell where you want to get the result.


Type the formulaPin
Type the formula
  • 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.


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:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...