| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use a cell value to select a sheet tab?
I want to be able to use values in column A (which match the names of the
worksheet tabs in my workbook), to select which sheet I look up (using VLOOKUP) values in column B from (which contain values contained in one of those sheets). I remember I did this once before using INDIRECT or something similar but I can't remember exactly how - can anyone help? Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking sheet - Formula Match Exact or select next row and cell | Excel Discussion (Misc queries) | |||
| hyperlink - clicking on hyper link to select cell in another sheet | Excel Worksheet Functions | |||
| Select sheet from cell value | Excel Discussion (Misc queries) | |||
| View, scroll and select a cell value from another Excel sheet? | Excel Worksheet Functions | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
![Monkey-See, Monkey-Do[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
