| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect Function
In Range A1:B3 of WorkBook2.xls I have:
A B 1 From Excel FileName: -- Temp11 2 From Sheet Name: -- Bob 3 From Cell Address: -- A1 In Cell B5 =INDIRECT(B1&$B$2&"!"&B3) But currently B5 is showing #REF! Can someone spot my problem? TIA, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why is the INDIRECT function volatile? | Excel Worksheet Functions | |||
| consolidate data using 3d function AND indirect | Excel Worksheet Functions | |||
| INDIRECT function inside AND function | Excel Worksheet Functions | |||
| Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
| include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
Threaded Mode
