Reference
 

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

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

"starfighter61" wrote:

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

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


starfighter61 wrote:
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

Thanks

"Frank Kabel" skrev:

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

"starfighter61" wrote:

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