Hi
ANy updates on this??
If I use INDIRECT function then I have to keep open both the XLs. I don't
want to do that? what is other alternative?
Basically I want to give reference to some other XL which I can storeon the
same folder but I dont want to open it. And the formula which I have written
has length approx 512.
How to hardcode path in formulas?
Milind
:
Thanks Pete!!
I haven't yet used INDIRECT function but I will use it...
SUM(IF(([GlobalReport.xls]TBL_Adhoc_Supervised_UIX!$B$1:$B$65000 =
Data!$A$3)*([GlobalReport.xls]TBL_Adhoc_Supervised_UIX!$D$1:$D$65000 =
Data!$B$3)*([GlobalReport.xls]TBL_Adhoc_Supervised_UIX!$AL$1:$AL$65000 =
Data!$C$3)*([GlobalReport.xls]TBL_Adhoc_Supervised_UIX!$AP$1:$AP$65000 =
Data!$D$3)*([GlobalReport.xls]TBL_Adhoc_Supervised_UIX!$BD$1:$BD$65000 =
Data!$E$3)*([GlobalReport.xls]TBL_Adhoc_Supervised_UIX!$BF$1:$BF$65000 =
Data!$F$3)*([GlobalReport.xls]TBL_Adhoc_Supervised_UIX!$BH$1:$BH$65000 <>
Data!$G$3),[GlobalReport.xls]TBL_Adhoc_Supervised_UIX!$EM$1:$EM$65000,"false"))
This is my formula.... 'GlobalReport.xls' is data sheet.
Now here i want to use INDIRECT Function for name of the datasheet as
evrytime it is different file.
A1 = [GlobalReport.xls]TBL_Adhoc_Supervised_UIX!$B$1:$B$65000
Here i would like to do something like dis,
SUM(IF((INDIRECT(A1) =
Data!$A$3)*([GlobalReport.xls]TBL_Adhoc_Supervised_UIX!$D$1:$D$65000 =
Data!$B$3)*([GlobalReport.xls]....>>
Can I do this? will this work??
And do I need to give path of the datasheet?
Currently I am getting following error,
"Excel Can not complete this task with available resource, chose less data
or close other application"
"Unable to save external link value"
Why am I getting this error??
:
Is the file Data an Excel file? Is it open at the same time as the
file with the formula in? If so, you can do this:
A1 = [Data.xls]UK!B7
Then in your formula you can put:
=IF(INDIRECT(A1) = "Milind", "Exist", "Does not Exist")
INDIRECT only works with open workbooks.
Hope this helps.
Pete
On Sep 3, 12:42 pm, Milind Keer <
[email protected]>
wrote:
Hi
=IF ([Data] UK!B7 = "Milind", "Exist", "Does not Exist")
here can I give reference to '[Data] UK!B7'??
e.g
A1 = [Data] UK!B7
Can I say
=IF (A1 = "Milind", "Exist", "Does not Exist")
basically i want to pull '[Data] UK!B7' from some othr cell... as dis is
dynamic in my case... it keeps changing all the time and evry time i dont
want to modify my formula... i dont even want to do find-replace.
plz advise.- Hide quoted text -
- Show quoted text -- Hide quoted text -