Thread: Reference
View Single Post
  #1   Report Post  
starfighter61
 
Posts: n/a
Default 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