Excel Nested If-Then Search by a string * * for a specific text?

You can either use autofilter or pivottables to get exactly what you want. No need for any 'rocket science' if formulas.