Thank you for your efforts. I'm very appreciative!! I see what this is doing and it is interesting. I will explore it to see if I can make use of it.
The only difference in its execution from our original intentions is that if a user selects "Toys" in Q2 or Q3, it is only searching Category 1 data. We meant for it to search all 3 categories, otherwise users will have to enter "Toys" in all 3 columns to find all the Names for Toys data.
Bookmarks