How to Get Cell Value by Address in Excel: 6 Simple Methods

Method 1 – Get Cell Value Using ADDRESS Function

Steps:

  • Go to cell D4 and insert the following formula:
=INDIRECT(ADDRESS(10,2))

address function to get cell value in excel

  • Press Enter and this will find the item that you are looking for.
  • Copy this formula to other cells and modify the criteria to find other items.


Method 2 – Utilizing INDEX Function

Steps:

  • Double-click on cell D6 and enter the below formula:
=INDEX(B4:D10,4,1)

index function to get cell value by address in excel

  • Press the Enter key, which should retrieve the cell value according to the set criteria.


Method 3 – Applying INDIRECT Function

Steps:

  • Double-click on cell D6 and insert the formula below:
=INDIRECT("R" & D4 & "C" & D5,FALSE)

indirect function to get cell value by address in excel

  • After pressing Enter, you should get the desired item in cell D6.


Method 4 – Combining MAX and MIN Functions

Steps:

  • Navigate to cell E4 and type in the following formula:
=MAX(C5:C10)

max and min functions to get cell value by address in excel

  • Press the Enter key and insert the following formula in the cell E5:
=MIN(C5:C10)
  • This should give the maximum and minimum values of the sales units.


Method 5 – Finding Cell Column Letter

Steps:

  • Go to cell C5 and insert the following formula:
=SUBSTITUTE(ADDRESS(5,B5,4),"5","")

column letter to get cell value by address in excel

  • Click on any empty cell and copy this formula to the below.
  • You should see the column letter of the respective input column numbers.


Method 6 – Using VBA Code

Steps:

  • Go to the Developer tab and select Visual Basic.

opening VBA to get cell value by address in excel

  • Select Insert in the VBA window and click on Module.

inserting module to get cell value by address in excel

  • Type in the formula below in the new window:
Function CellValue(rowNum As Integer, colNum As Integer)
CellValue = ActiveSheet.Cells(rowNum, colNum)
End Function

VBA code to get cell value by address in excel

  • Navigate to cell D6 and type in the below formula:
=CellValue(D4,D5)

  • Press the Enter key and the VBA function will find the cell value accordingly.


Download Practice Workbook

You can download the practice workbook from here.


Related Articles


<< Go Back to Excel ADDRESS Function | Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nazmul Hossain Shovon
Nazmul Hossain Shovon

Nazmul Hossain Shovon, a BUET graduate in Naval Architecture and Marine Engineering, embarked on his career with 8 months dedicated to the Exceldemy project's triumph. Transitioning into a Software Developer role, he specialized in web add-in development. At Exceldemy, he authored about 125 blog articles and solved many visitors’ problems, refining his writing skills and delving into Excel-related topics. With a primary passion for programming and software development, Shovon continually explores new horizons, fostering professional growth in his... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo