Looking for a formula

N

Natalie

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?
 
N

Natalie

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.
 
S

Sandy Mann

Mike,

The UPPER() function is not required because Worksheet functions are not
case sensative

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top