This would only work if Add-PO was the only thing in column A though? I want
it to return it if contains Add-PO.

"Mike" wrote:

=IF(UPPER(A1)="ADD-PO","YES","")

"Natalie" wrote:

I have the following in column A

Add-PO, DEL-PO, ISS-SO,

and I want to do a function in column B to say IF column A contains Add-PO,
then YES, if not, then leave blank.

Can I do this?