Good afternoon all,
Here's what I'm trying to accomplish:
A: Description | B: Name | C: Box Number
Above are example headers of my columns. I'm looking for specific names/keywords from A & B, BUT I also want all of the Box Number hits that appear from the search of A & B.
Basically:
Search Column A for "keyword" AND Column B for "name" - additionally, I want all of the entries for Box 1 if that Box 1 is part of the initial A & B search hit (regardless of having the keyword/name).
If this sounds confusing, I will try to re-word it
Thanks!