| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect Formula Problem
Hi,
I'm having trouble using the INDIRECT formula below =INDIRECT("'06 07 rnl(&A5&)'!$C$4") It returns a reference problem. A5 is the cell worksheet number, there are multiple worksheets named 06 07 rnl (#) where # can be any number from 1-115. Any suggestions on how to fix this? Cheers |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Indirect Formula Problem
=INDIRECT("'06 07rnl(" & A5 & ")'!C4")
-- Gary's Student gsnu200703 "sid@knee" wrote: Hi, I'm having trouble using the INDIRECT formula below =INDIRECT("'06 07 rnl(&A5&)'!$C$4") It returns a reference problem. A5 is the cell worksheet number, there are multiple worksheets named 06 07 rnl (#) where # can be any number from 1-115. Any suggestions on how to fix this? Cheers |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Indirect Formula Problem
I think you need to do this:
=INDIRECT("'06 07 rnl("&A5&")'!$C$4") Hope this helps. Pete On Jan 30, 12:28 am, sid@knee wrote: Hi, I'm having trouble using the INDIRECT formula below =INDIRECT("'06 07 rnl(&A5&)'!$C$4") It returns a reference problem. A5 is the cell worksheet number, there are multiple worksheets named 06 07 rnl (#) where # can be any number from 1-115. Any suggestions on how to fix this? Cheers |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Indirect Formula Problem
Thanks Guys...
Cheers "Pete_UK" wrote: I think you need to do this: =INDIRECT("'06 07 rnl("&A5&")'!$C$4") Hope this helps. Pete On Jan 30, 12:28 am, sid@knee wrote: Hi, I'm having trouble using the INDIRECT formula below =INDIRECT("'06 07 rnl(&A5&)'!$C$4") It returns a reference problem. A5 is the cell worksheet number, there are multiple worksheets named 06 07 rnl (#) where # can be any number from 1-115. Any suggestions on how to fix this? Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula percentage problem | New Users to Excel | |||
| problem with Array Formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Hybrid Mode
