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

=IF(OR(ISNUMBER(SEARCH($N$2,$D54)),ISNUMBER(SEARCH ($N$2,$F54))),IF($G540,$G54,$H54),0)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Tester" wrote in message
...
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