Entering row value in Excel formula from cell
Closed
Marc
-
Feb 9, 2011 at 11:18 PM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Entering row value in Excel formula from cell
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
- Excel formula if cell contains date ✓ - Forum - Office Software
- How to move rows automatically in excel based on cell value ✓ - Forum - Excel
- Excel formula if cell contains multiple text ✓ - Forum - Excel
- Excel formula if cell contains date then return date in another cell ✓ - Forum - Excel
1 reply
rizvisa1
Feb 9, 2011 at 11:42 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Feb 9, 2011 at 11:42 PM
You have to use for each column of sheet2, indirect and address function
example on cell B1 you have this
=IF(A1="", "", INDIRECT(ADDRESS(A1,1,1,TRUE,"Sheet1")))
This will look at the row number from cell A1
then will return the text from the row number mentioned, the cell value of column 1 from sheet1
for C1 you would need
=IF(A1="", "", INDIRECT(ADDRESS(A1,2,1,TRUE,"Sheet1")))
example on cell B1 you have this
=IF(A1="", "", INDIRECT(ADDRESS(A1,1,1,TRUE,"Sheet1")))
This will look at the row number from cell A1
then will return the text from the row number mentioned, the cell value of column 1 from sheet1
for C1 you would need
=IF(A1="", "", INDIRECT(ADDRESS(A1,2,1,TRUE,"Sheet1")))