This is my formula
=IF(ISERR((SEARCH($N$2,OR($D54,$F54),1)0)),0,IF($ G540,$G54,$H54))

At the moment the OR function doesn't seem to work, i.e. when i run a test i
get zero - any ideas please
The search is referring to text in a header cell and searches 2 cells in
different columns containing text for the same string (not case sensitive)
amongst the entire content. Provided there is no error it then displays the
figure which appears in either colum G or H.
Well, it should!!

TIA
Chris