| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Results of a cell based on cell referenced in a cell
I am trying to write a formula that will return the results of a cell based
on cell coordinates (including sheet where located and cell within that sheet (column and row)). Is anyone aware of how to do this? Thanks, -- Drew |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return Results of a cell based on cell referenced in a cell
=INDEX(Sheet1!A1:J10,5,5)
returns contents from 5th row 5th column of array Sheet1!A1:J10 If this post helps click Yes --------------- Jacob Skaria "Drew" wrote: I am trying to write a formula that will return the results of a cell based on cell coordinates (including sheet where located and cell within that sheet (column and row)). Is anyone aware of how to do this? Thanks, -- Drew |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return Results of a cell based on cell referenced in a cell
Drew wrote:
I am trying to write a formula that will return the results of a cell based on cell coordinates (including sheet where located and cell within that sheet (column and row)). Is anyone aware of how to do this? Thanks, Does this help? http://www.contextures.on.ca/xlFunctions05.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return Results of a cell based on cell referenced in a cell
I should have provided more detail. Within my spreadsheet, I have one cell
that refers to a tab (Store 1) and another cell that refers to the cell within that tab where the data that I want to return resides (c10). Is there a formula that I can use that will return the information that I want by referencing the two cells where the tab and cell information resides? i.e. =index(c9 (tab data), c10 (cell data to return within that tab). Thanks, -- Drew "Jacob Skaria" wrote: =INDEX(Sheet1!A1:J10,5,5) returns contents from 5th row 5th column of array Sheet1!A1:J10 If this post helps click Yes --------------- Jacob Skaria "Drew" wrote: I am trying to write a formula that will return the results of a cell based on cell coordinates (including sheet where located and cell within that sheet (column and row)). Is anyone aware of how to do this? Thanks, -- Drew |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return Results of a cell based on cell referenced in a cell
cell A1 = tabname
B1 = cell reference.. Try =INDIRECT("'" & A1 & "'!" & B1) If this post helps click Yes --------------- Jacob Skaria "Drew" wrote: I should have provided more detail. Within my spreadsheet, I have one cell that refers to a tab (Store 1) and another cell that refers to the cell within that tab where the data that I want to return resides (c10). Is there a formula that I can use that will return the information that I want by referencing the two cells where the tab and cell information resides? i.e. =index(c9 (tab data), c10 (cell data to return within that tab). Thanks, -- Drew "Jacob Skaria" wrote: =INDEX(Sheet1!A1:J10,5,5) returns contents from 5th row 5th column of array Sheet1!A1:J10 If this post helps click Yes --------------- Jacob Skaria "Drew" wrote: I am trying to write a formula that will return the results of a cell based on cell coordinates (including sheet where located and cell within that sheet (column and row)). Is anyone aware of how to do this? Thanks, -- Drew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| Highlight Cell Based Upon Referenced Cell Data | Excel Worksheet Functions | |||
| function CELL() to return the formula in the referenced cell | Excel Worksheet Functions | |||
| How can I return a cross referenced cell value? | Excel Worksheet Functions | |||
Linear Mode
