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