| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect function with r1c1 style
Sorry to waste your time. I closed all of the workbooks , reopened and
retyped the formula. Works now! Must have had a typo? Thanks for the help guys Zim "Zim" wrote: =INDIRECT("'[Direct FTC Tracking 2009.xls]"&R2C2&"'!R81C3",FALSE) This is the formula I am trying to use. What I am trying to accomplish is to return the value of Cell (R81C3) on variable Sheet (R2C2), in the workbook [Direct FTC Tracking 2009.xls] (Sheets are monthly and the reference of R2C2 is the current sheet date reference, which exactly matches the name of the sheets from the workbook [Direct FTC Tracking 2009.xls]) The formula returns #REF! Before I went to R1C1 style (for ease of VBA use) this formula worked like a charm and looked like this =INDIRECT("'[Direct FTC Tracking 2009.xls]"&$a$2&"'!$c$83",FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDIRECT & R1C1 Ref style | Excel Worksheet Functions | |||
| Sum Indirect Using R1C1 Style | Excel Worksheet Functions | |||
| How do I change sheet notation from R1C1 style to A1 style in XL 2 | Setting up and Configuration of Excel | |||
| can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
| R1C1 reference style | Excel Discussion (Misc queries) | |||
Threaded Mode
