Forum Discussion
Filtering Columns of Data (Named Ranges) based on Brand Names
See Sheet2 in the attached version. If it is not what you want, please explain.
In A2 on the second sheet:
=LET(f, VSTACK(FILTER(productLists, ISNUMBER(SEARCH(A1, productLists)), ""), FILTER(Clearance_Products, ISNUMBER(SEARCH(A1, Clearance_Products)), "")), FILTER(f, f<>"", ""))
Fill to the right.
Use
=LET(f, VSTACK(FILTER(productLists, ISNUMBER(SEARCH(" "&A1&" ", " "&productLists&" ")), ""), FILTER(Clearance_Products, ISNUMBER(SEARCH(" "&A1&" ", " "&Clearance_Products&" ")), "")), FILTER(f, f<>"", ""))
See the attached version.
Another quick question to another problem:
I don't want the filtered results to include results that include words/brands in which, "the word is in a part of another word"....For example, if the filter criteria is "Protect" and one of the products is "Speaker with 10-Year Protection Plan", is there any way to filter using only the word "Protect"...
Peter
- Yes... This works, thank you!!
See Sheet2 in the attached version. If it is not what you want, please explain.
Sorry, you've lost me again. What exactly do you want?