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
|