Imn English the formula is

=IF(IF(ISERROR(VLOOKUP($B1147,'JK-prisfil'!$C:$HG,DV$1,FALSE)),VLOOKUP($B1147,'2015p riser'!$B:$HG,DV$1,FALSE),VLOOKUP($B1147,'JK-prisfil'!$C:$HG,DV$1,FALSE))=0,ROUND(VLOOKUP($B114 7,'2015priser'!$B:$HG,DV$2,FALSE),0),ROUND(IF(ISER ROR(VLOOKUP($B1147,'JK-prisfil'!$C:$HG,DV$1,FALSE)),VLOOKUP($B1147,'2015p riser'!$B:$HG,DV$1,FALSE),VLOOKUP($B1147,'JK-prisfil'!$C:$HG,DV$1,FALSE)),0))

I have checked for Spaces, but I may have overlooked some. The names are spelled correct.

Jan


Den søndag den 26. oktober 2014 12.23.05 UTC+1 skrev Claus Busch:
Hi,

Am Sun, 26 Oct 2014 12:21:43 +0100 schrieb Claus Busch:

can you offer this formula in English?
I guess there is a typo anywhere in this formula

or the sheet name differs in spelling. Check for trailing or leading
spaces in the sheet names


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional