Aug 26 2021 12:39 PM
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
Aug 26 2021 12:47 PM
You may return filtered table by Power Query or as dynamic array using FILTER() function like
=FILTER(Table, COUNTIF(Table[Category],List1))
Aug 26 2021 12:56 PM
Aug 26 2021 02:00 PM
Could you please provide sample file removing all sensitive and unnecessary information? It will be much easier to demonstrate formula on it.
Aug 27 2021 10:05 AM
HI@Sergei Baklan I actually was able to figure it out! thanks for the help