# How to Use INDIRECT ADDRESS Functions in Excel (4 Examples)

Get FREE Advanced Excel Exercises with Solutions!

In this article, you will get to know some of the examples of the INDIRECT ADDRESS functions in Excel. By using an indirect address, you will be able to refer to the address of the cell rather than to the cell itself. So, let’s get started with the main article.

## Excel INDIRECT Function

### # Example 1: Used for Indirect Referencing

Here, we have two tables and we want to have the values of the sales of the first table in the second table in the Sales column. So, we can paste these values with indirect address referencing by using the INDIRECT function. ➤Select the output cell F5.
➤Type the following formula

`=INDIRECT("C"&ROW(C5))`
• ROW(C5)→ returns the row number of cell C5
Output→ 5
• INDIRECT(“C”&ROW(C5)) becomes
INDIRECT(“C5”)→ returns the value in cell C5
Output→ \$4,629.00 ➤Press ENTER.
➤Drag down the Fill Handle Tool. Result:
In this way, you will get the values of the sales in the Sales column of the second table by using indirect reference. ### # Example 2: Adding up Values with the Excel INDIRECT Function

Here, we will sum up the sales values by using indirect referencing. ➤Select the output cell D9.
➤Type the following formula

`=INDIRECT("D5")+INDIRECT("D6")+INDIRECT("D7")+INDIRECT("D8")`
• INDIRECT(“D5”)→ returns the value in the cell D5
Output→ \$4,629.00
• INDIRECT(“D6”)→ returns the value in the cell D6
Output→ \$3,257.00
• INDIRECT(“D7”)→ returns the value in the cell D7
Output→ \$2,091.00
• INDIRECT(“D8”)→ returns the value in the cell D8
Output→ \$2,125.00
• INDIRECT(“D5”)+INDIRECT(“D6”)+INDIRECT(“D7”)+INDIRECT(“D8”)→ becomes
\$4,629.00+\$3,257.00+\$2,091.00+\$2,125.00
Output→ \$12,102.00 ➤Press ENTER.

Result:
After that, you will get the sum of sales in the D9 cell. ## 1. Combining Excel INDIRECT ADDRESS Functions to Copy Values From Another Sheet

Here, we have three different sheets named January, February, and March and each of them contains the sales of the products.   Now, we will paste the sales values from these sheets in the following table in the corresponding column of these months by using indirect address reference. ➤Select the output cell C5.
➤Type the following formula

`=INDIRECT("January!"&ADDRESS(ROW(D5),COLUMN(D5)))`
• ROW(D5)→returns the row number of the cell D5
Output→ 5
• COLUMN(D5)→returns the column number of the cell D5
Output→ 4
Output→\$D\$5
INDIRECT(“January!”&”\$D\$5”)INDIRECT(“January!\$D\$5”)
Output→\$4,629.00 ➤Press ENTER.
➤Drag down the Fill Handle Tool. Then, you will get the sales record of January month from the January sheet in the January column. Similarly, you can get the sales record for  February and March by using the following formulas

`=INDIRECT("February!"& ADDRESS(ROW(D5),COLUMN(D5)))` `=INDIRECT("March!"& ADDRESS(ROW(D5),COLUMN(D5)))` ## 2. Using the INDIRECT Function and ADDRESS Function of Excel for Indirect Referencing

Here, we want to have the values of the sales of the first table in the second table in the Sales column. So, we can paste these values with indirect address referencing by using the INDIRECT function and the ADDRESS function. Besides these, we will use the row numbers of Row No. column. ➤Select the output cell G5.
➤Type the following formula

`=INDIRECT(ADDRESS(D5,3))`
• D5→ returns the value in the cell D5
Output→ 5
Output→ \$C\$5
INDIRECT(“\$C\$5”)
Output→ \$4,629.00 ➤Press ENTER.
➤Drag down the Fill Handle Tool. Result:
Then, you will get the values of the sales in the Sales column of the second table by using indirect reference. ## Practice Section

For doing practice by yourself we have provided a Practice section like below in a sheet named Practice. Please do it by yourself for a better understanding of the INDIRECT ADDRESS functions in Excel. ## Conclusion

In this article, we tried to cover some of the examples of INDIRECT ADDRESS functions in Excel. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems. Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  