I think I'm following what you are saying but I'm not 100% sure....

What I'm running into is Transportation1, Transporation2, Transporation3, will be under it's own Criteria List with it's own DefinedRange which then would have to be added to the Added to "Added to Criteria" formula.

=IF(SUMPRODUCT(--ISNUMBER(SEARCH(Restaurants,A2))),"Done",IF(SUMPRODUCT(--ISNUMBER(SEARCH(Utility,A2))),"Done",IF(SUMPRODUCT(--ISNUMBER(SEARCH(Transportation,A2))),"Not Done")))


So, what I have is a couple of statements with 1500 items, I was putting together some DefiniedRange to use as a Criteria List. I wanted to add a column to reflect if I've added that criteria to the multiple DefinedRange lists. But, my formula in Added to Criteria is growing by
IF(SUMPRODUCT(--ISNUMBER(SEARCH(Restaurants,A2))),"Done"
on every DefinedRange I make. I was hoping for something simplified.

Maybe I'm missing what you are saying.... I'm not sure.