[Solved] Using multiple text values in same range to get an answer

[sharyn]

Hi,
I haven't been able to find a solution for this issue.
I have a list of options (red, green, blue, black) in a column.

I want to be able to give a yes answer to 'does the range contain red and green').

I've tried IF(AND(ISNUMBER(SEARCH..... but if I change the values in the list, it doesn't work any longer.
This is to go in a template sheet, to automatically provide the answer.

Any suggestions please?
Thanks

 

[Saquib]

Greetings. You can easily solve the problem by using the following formula.
=IF(AND(ISNUMBER(MATCH(E2,B2:B6,0)),ISNUMBER(MATCH(E3,B2:B6,0))),"Yes","No")

You can find the solution to the problem in the Excel workbook below.

 

[sharyn]

Thank you! That's working!

 

[shamimarita]

Thank you! That's working!

Dear Sharyn,

Hope you are doing well. Thank's for your appreciation. Keep sharing your question and queries with us.