Richard -

the "'LoB'!K44"-Reference would have to be replaced in several different types of formulas. The two most frequent versions are the following:

(i.) ='LoB'!K44

(ii.) =IF('LoB'!K44="";J180;'LoB'!K44)

The (ii.) version I'd guess is the more difficult case where the reference occurs twice in the formula. - i.e. the case you mentioned.

Thank you for your help!

Rgds,
Alain.