| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use Indirect to Select Worksheet
Good evening --
I have three lookup tables, and would like the user to be able to select which one (s)he wants. They are pretty much identical, on worksheets named "2008", "2009", and "2010". On the active worksheet, cell F3 allows the user to select which one to use. How do I use INDIRECT to select cell A1 on a worksheet selected by an entry in cell F3? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect worksheet function | Excel Discussion (Misc queries) | |||
| Indirect Select | Excel Discussion (Misc queries) | |||
| Indirect worksheet function | Excel Worksheet Functions | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Threaded Mode
