| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to match Cell with table of contents
I currently have a Hyperlink table of contents listing each tab. This is
listed in column C. I would like to match a cell (example E400) of each tab with each Table of Contents in column D. This would give me a summary of each tab next to the TOC list. This would help looking up any tab with significant balances. Thanks!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to match Cell with table of contents
something like:
=INDIRECT("'"&C2&"'!E400") -- Best Regards, Luke M "Terry" wrote in message ... I currently have a Hyperlink table of contents listing each tab. This is listed in column C. I would like to match a cell (example E400) of each tab with each Table of Contents in column D. This would give me a summary of each tab next to the TOC list. This would help looking up any tab with significant balances. Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autofit cell height and width to match bitmap contents | Excel Worksheet Functions | |||
| Table of Contents (Exact match Hyperlinks?) | Excel Worksheet Functions | |||
| use cell reference,whose contents= a table array name for Vlookup | Excel Worksheet Functions | |||
| Edit macro to match entire cell contents | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Linear Mode
