| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Indirect Help
HI All, I need to give this '*\\10.10.1.80\Miscellaneous\Adarsh\Calculation\[OAR Coupon - Timesheet - Satheesh.xls]Timesheet'!D5* string as argument to Indirect function . I tired several combination of single and double quotes but iam not able to get the correct result using formula .Can any one please help Thanks in advance Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=401425 |
|
#2
|
|||
|
|||
|
Presumably you tried
=INDIRECT("'*\\10.10.1.80\Miscellaneous\Adarsh\Cal culation\[OAR Coupon - Timesheet - Satheesh.xls]Timesheet'!D5") -- HTH RP (remove nothere from the email address if mailing direct) "xcelion" wrote in message ... HI All, I need to give this '*\\10.10.1.80\Miscellaneous\Adarsh\Calculation\[OAR Coupon - Timesheet - Satheesh.xls]Timesheet'!D5* string as argument to Indirect function . I tired several combination of single and double quotes but iam not able to get the correct result using formula .Can any one please help Thanks in advance Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=401425 |
|
#3
|
|||
|
|||
|
yes i tired the same but i don't understabd what is * in your formula =INDIRECT("'*\\10.10.1.80\Miscellaneous\Adarsh\Cal culation\[OAR Coupon - Timesheet - Satheesh.xls]Timesheet'!D5") -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=401425 |
|
#4
|
|||
|
|||
|
=indirect() will return an error if it refers to a closed workbook.
xcelion wrote: HI All, I need to give this '*\\10.10.1.80\Miscellaneous\Adarsh\Calculation\[OAR Coupon - Timesheet - Satheesh.xls]Timesheet'!D5* string as argument to Indirect function . I tired several combination of single and double quotes but iam not able to get the correct result using formula .Can any one please help Thanks in advance Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=401425 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nested Indirect to other WS | Excel Worksheet Functions | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Sum Indirect function through multiple sheets | Excel Discussion (Misc queries) | |||
| is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
| Indirect another wookbook | Excel Worksheet Functions | |||
Hybrid Mode
