Hi, I'm working on organizing a credit card statement.

I've made some or bunch of named ranges to categories the statement. I decided to make an additional column that stated weather this line had been added to a named range.

=IF(SUMPRODUCT(--ISNUMBER(SEARCH(NamedRange1,C2))),"Done","Not Done"))

This works well. To add another Named Range to be check I made an additional IF statement.

=IF(SUMPRODUCT(--ISNUMBER(SEARCH(NamedRange1,C2))),"Done",IF(SUMPRODUCT(--ISNUMBER(SEARCH(NamedRange2,C2))),"Done","Not Done")))

As you can imagine this is getting ridiculous in size. But, I can't seem to figure out how to add multiple named ranges to be search/checked against C2.

For Example:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH(NamedRange1,NamedRange2,C2))),"Done","Not Done"))
or
=IF(SUMPRODUCT(--ISNUMBER(SEARCH({NamedRange1,NamedRange2},C2))),"Done","Not Done"))
Obviously neither of these worked....

There is probably a much way better solution for this, which I'm would love to hear. Or Any additional thoughts.

Thank you!