Looking for a formula

  • Thread starter Thread starter Natalie
  • Start date Start date
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?
 
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,

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Countif and sumif combination problem 2
Matching data in 2 different work sheets 3
Looking up next available number 3
Multiple criteria in 2 different columns for a sum in a 3rd column 6
Copy Data from 1 Sheet to Another 3
sumif error 4
Find values on another sheet 5

Back
Top