Get Cell Value Based on Row and Column Numbers

This post will guide you how to retrieve values using references based on Row and Column numbers in excel. How to get the cell value based on row and column numbers with an excel formula or user defined function in excel.

Get Cell Value Based on Row and Column Numbers


If you want to retrieve values using cell references based on row and column numbers, you can create a formula based on the INDIRECT function and the ADDRESS function.

Assuming that there is a row number in cell D1 and there is a column number in cell D2, if you want to retrieve the cell value based on the specified row number and column number, just type the following formula in cell D3:

=INDIRECT(ADDRESS(D1,D2))

get cell value1

You can also write a User Defined Function to get content of a cell given the row and column numbers. Just do the following steps:

#1 open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.

Get the position of the nth using excel vba1

#2 then the “Visual Basic Editor” window will appear.

#3 click “Insert” ->”Module” to create a new module

convert column number to letter3

#4 paste the below VBA code into the code window. Then clicking “Save” button.

get cell value2

Function GetCellValue(row As Integer, col As Integer)
    GetCellValue = ActiveSheet.Cells(row, col)
End Function

#5 back to the current worksheet, try to enter the below formula in Cell D4.

=GetCellValue(2,1)

get cell value3

Related Functions


  • Excel ADDRESS function
    The Excel ADDRESS function returns a reference as a text string to a single cell.The syntax of the ADDRESS function is as below:=ADDRESS (row_num, column_num, [abs_num], [a1], [sheet_text])….
  • Excel INDIRECT function
    The Excel INDIRECT function returns the cell reference based on a text string, such as: type the text string “A2” in B1 cell, it just a text string, so you can use INDIRECT function to convert text string as cell reference….

 

Comments

So empty here ... leave a comment!

Leave a Reply

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

Sidebar