Hi, I want to create a formula that returns a "1" if a criteria is not one of the invalid options. In my sample, Classification (column B) lists all the various transaction classifications. The table at column F lists the Invalid Classifications. Any classification that matches on of the ones listed in the Invalid Table (F) should return a zero in Column D (Valid). All other classifications should return a "1" in column D. Thx for your help
Bookmarks