Hi there,

Does the following formula in Cell B4 do what you need?


=IF(AND(A4 <> "",  D10 = "Yes"),  HelligdagsNavn(A4,0,0),  "")

Hope this helps - please let me know how you get on.

Regards,

Greg M