Forum Discussion
Filter
HI! so I have a list of items (1) that I want to search in another doc that has several columns. How can I filter a list into another doc so the items come up as well as other data related. first pic is the list I want to search and second pic is where I want to search it
6 Replies
You may return filtered table by Power Query or as dynamic array using FILTER() function like
=FILTER(Table, COUNTIF(Table[Category],List1))
- hi thank you for your answer! I am not the best at excel so which cells would go in the 1 Table and 2 table and category and list 1 haha
Could you please provide sample file removing all sensitive and unnecessary information? It will be much easier to demonstrate formula on it.
- how do I do it?? pls help!!
