Reference

[Guest]

Hi
I am using this formula to get value from other workbook
=INDIREKT("'[Franvaro" & E2 & "v" & K2 & C5 & ".xls]Sammandrag'!$B$201")

but lets say that workbook don´t exist
then i get a #REFERENCE in the cell
Is it possible to get a 0 instead

 

[Guest]

Hi
try
=IF(ISERROR(INDIRECT(...)),0,INDIRECT(...))

 

[Govind]

Hi,

Use

=IF(ISERROR(INDIREKT("'[Franvaro" & E2 & "v" & K2 & C5 &
".xls]Sammandrag'!$B$201")),0,INDIREKT("'[Franvaro" & E2 & "v" & K2 & C5
& ".xls]Sammandrag'!$B$201"))

Btw, the formula has been spelt as "INDIREKT" instead of "INDIRECT".Is
that a different language version of excel or a typo error?

Regards

Govind

 

[Guest]

Thanks

"Frank Kabel" skrev:

Hi
try
=IF(ISERROR(INDIRECT(...)),0,INDIRECT(...))

Hi
I am using this formula to get value from other workbook
=INDIREKT("'[Franvaro" & E2 & "v" & K2 & C5 & ".xls]Sammandrag'!$B$201")

but lets say that workbook don´t exist
then i get a #REFERENCE in the cell
Is it possible to get a 0 instead