In article , Don Guillett
writes
=IF(AND(RIGHT(E2,2)="1bx",j2=11),1,j2)



Hi Don

OK Thanks for that.

I can't quite get it to work though , for what I have in mind.

I found that this works for a single search parameter :

=IF(AND(COUNTIF(E2,"*1bx*"),COUNTIF(J2,"11")),1,J2 )

but of course it only looks for "*1bx*". I need in incorporate an OR
expression to also search for "*2bx*" , "*3bx*" and "*4bx*" in the same
formula.

Any ideas how to work these other values in?

Thanks for your help.

Best Wishes