| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I reference data from a sheet specified by text in a cell
I am trying to use the text generated in a certian cell as part of a function
which will reference the appropriate sheet and pull information from a certian row. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I reference data from a sheet specified by text in a cell
Use INDIRECT.
http://www.officearticles.com/excel/...ft_excel.h tm ************ Hope it helps! Anne Troy www.OfficeArticles.com "RedWolf" wrote in message ... I am trying to use the text generated in a certian cell as part of a function which will reference the appropriate sheet and pull information from a certian row. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| How can I reference data or text within a text box to a cell in Ex | Excel Discussion (Misc queries) | |||
| Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
Hybrid Mode
