The indirect() function returns the reference specified by a text string. For your example you can obtain the value in cell A2136, based on the value in cell P1 by using the following formula: =indirect(A & P1)
https://www.quora.com/How-can-I-return-the-value-of-a-specific-cell-in-Excel
The COLUMN function is a computer program that you run from a worksheet cell formula. It determines the column number of a single cell or the column numbers of the range you specify. You run the COLUMN worksheet function by typing its name in a formula then followed by the information it is suppose to analyze. The sole use of this function is to return the column numbers of a specified range or cell.
http://www.emagenit.com/Functions/column-function.htm
INDEX reference form - things to remember. 1  If the row_num or column_num argument is set to zero (0), an Excel INDEX formula returns the reference for the entire column or row, respectively. 2  If both row_num and column_num are omitted, the INDEX function returns the area specified in the area_num argument.
https://www.ablebits.com/office-addins-blog/2015/02/18/excel-index-function/
The following OFFSET formula returns a cell reference based on a starting point, rows and cols that you specify: =OFFSET(A1,3,1) The formula tells Excel to take cell A1 as the starting point (reference), then move 3 rows down (rows argument) and 1 column to the left (cols argument). As the result, this OFFSET formula returns the value in cell B4.
https://www.ablebits.com/office-addins-blog/2015/02/11/excel-offset-function/
This article describes how to use the INDEX function to find data in a table at the intersection of a specific row and column in Microsoft Excel. There are two forms of the INDEX function, Array and Reference. The primary differences between the two forms are as follows: The Array form can return more than one value at a time.
https://support.microsoft.com/en-us/help/324988/how-to-use-the-index-function-to-find-data-in-a-table-in-excel
=INDIRECT(A & 2136) --> =INDIRECT(A2136) --> =A2136. NOTE: The indirect function is a volatile function, which means it will recalculate every time there is a change in your spreadsheet. Depending on the amount of volatile functions you have on your spreadsheet, your spreadsheet's recalculation time may suffer.
https://www.quora.com/How-can-I-return-the-value-of-a-specific-cell-in-Excel
What is the Microsoft Excel COLUMN Function? The COLUMN function is a computer program that you run from a worksheet cell formula. It determines the column number of a single cell or the column numbers of the range you specify. Whenever you type a formula in a worksheet cell, this is called syntax or grammar.
http://www.emagenit.com/Functions/column-function.htm
If the row_num or column_num argument is set to zero (0), an Excel INDEX formula returns the reference for the entire column or row, respectively. If both row_num and column_num are omitted, the INDEX function returns the area specified in the area_num argument.
https://www.ablebits.com/office-addins-blog/2015/02/18/excel-index-function/
If the array argument consists of only one row or column, you may or may not specify the corresponding row_num or column_num argument. If the array argument includes more than one row and row_num is omitted or set to 0, the Excel INDEX function returns an array of the entire column.
https://www.ablebits.com/office-addins-blog/2015/02/18/excel-index-function/
Related QuestionsMore Answers Below. 1  How can I look up a value in Excel and then return the cell value below what I looked up? 2  How do I extract a specific cell value (Excel) by using iMacro? 3  Can I, using Excel, have a cell display a value based on a value in an adjacent cell and how that value relates to another table?
https://www.quora.com/How-can-I-return-the-value-of-a-specific-cell-in-Excel
excel specify column in function
The COLUMN function is a computer program that you run from a worksheet cell formula to determine the column number of a single cell or the column numbers of the range you specify. In Excel, Column function is a computer program that you run from a worksheet cell formula.