Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

Hello,

I am seeking help in writing a formula that will return YES if the Supplier is Xomo AND if the Supplier Bisum job titles do not contain Manager.


Supplier Job Title Include? (Yes or No)
Xomo Analyst
Bisum Manager II
Bisum Manager III
Crisin Manager II
Bisum Manager III
Bisum Clerk
Xomo Manager III
Bisum Manager II
Bisum Technician
Bidder Manager I

Try this in C2:

=IF(OR(A2="Xomo",AND(A2="Bisum",COUNTIF(B2,"*Manager*")=0)),"Yes","No")

then copy down as required.

Hope this helps.

Pete

Hi Sam,

I have found that when you see a badly-formatted table like the one in Post #1, you can click on Reply With Quote, and then you can usually see more clearly how the original table appeared. You can click on Cancel to abandon that Reply.

Hope this helps.

Pete

You're welcome, Sam - thanks for the rep.

Pete

Hi Pete,

It works perfectly!!! I really appreciate you. Thanks so much!

Thanks, Sam!

You're welcome - glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can show your appreciation directly and thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete