| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look up sheet name determined in cell
I have a table that has a set of values (formated MMM123) and their
corresponding numbers(formated 123). I would like to reference data from the corresponing sheet number(sheetname='123') based on the the original value(MMM123). What this would all do is when looking up a cell in another sheet(VIEWDATA) it would check the table to find which number sheet('123') and then display data found in in a cell on that sheet. What would be the best way to go about doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word link to open an excel book in a previous determined sheet | Links and Linking in Excel | |||
| Sheet name determined by cell value in INDEX/MATCH | Excel Discussion (Misc queries) | |||
| Insert # of Rows determined by cell | Excel Discussion (Misc queries) | |||
| Getting a value from a cell that is determined by a formula | Excel Discussion (Misc queries) | |||
| How do I generate a sum, determined by cell color? | Excel Worksheet Functions | |||
Threaded Mode
