If there a way to write a formula that queries, basically, IF value X is in column C OR column D, then Y.
I just want to be able to filter a base to show only the records where a Name appears in either one of two columns, if that makes sense.
I wish ...