Hi,



Can someone please help me identify why my if&and formula didn't work?

I attached an example sheet to show how the formula was formed.

Many thanks,
Haha

Attached Files

If&And formula.xlsx (9.9 KB, 11 views)

Do you mean =IF(ISNUMBER(FIND("Database Management",A3)),"YES","NO")

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Pecoflyer has already given you a solution, but I also think that you are almost there yourself. Just change AND to OR and C3 to A3.

=IF(OR(A3="Database Management - Data Migration",A3="Database Management"),"YES","NO")

Thank you both. It works brilliantly.