In article , T. Valko
writes
The formula would need to look specifically
for any of the 4 phrases ("*1bx*" OR "*2bx*"
OR "*3bx*" OR "*4bx*") contained anywhere in E2.

Try this...

=IF(COUNT(SEARCH({1,2,3,4}&"BX",E2))*(J2=11),1,J2 )



HI Biff

Yes , that's got it. Perfect first time.

Thanks for your time and expertise.



Best Wishes