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

1. ## 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

2. ## Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

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

3. ## Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

given what you wrote, this is what I came up with... =IF(OR(A2="xomo analyst",A2="bisum clerk",A2="bisum technician"),"yes","no")
but it is dependent on the list in post #1 being complete as far as the three different classifications of analyst, clerk and technician.

EDIT: and I'm assuming the titles are in the same cell while Pete's assumes the titles are split.

4. ## Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

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

5. ## Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

Oh, cool, always learning something on here. Thanks for the tip Pete.

6. ## Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

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

Pete

7. ## Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

Hi Pete,

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

Thanks, Sam!

9. ## Re: Formula to return Yes if the Supplier is Xomo and if the Supplier Bisum job title

You're welcome - glad to help.

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

There are currently 1 users browsing this thread. (0 members and 1 guests)