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:

• 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:

• 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:

• 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:

• Press the Enter key and insert the following formula in the cell E5:

• 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:

• 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.

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

• Type in the formula below in the new window:

Function CellValue(rowNum As Integer, colNum As Integer)
CellValue = ActiveSheet.Cells(rowNum, colNum)
End Function

• Navigate to cell D6 and type in the below formula:

• 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

• How to Use Cell Address in Excel Formula
• How to Return Cell Address of Match in Excel
• How to Copy Cell Address in Excel

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