Entering row value in Excel formula from cell
Closed
Marc
-
Feb 9, 2011 at 11:18 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 11:42 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 11:42 PM
Related:
- Entering row value in Excel formula from cell
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- How to enter @ in laptop - Guide
- Saints row 2 cheats - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2011 at 11:42 PM
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")))