Filter

%3CLINGO-SUB%20id%3D%22lingo-sub-2689550%22%20slang%3D%22en-US%22%3EFilter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2689550%22%20slang%3D%22en-US%22%3E%3CP%3EHI!%20so%20I%20have%20a%20list%20of%20items%20(1)%20that%20I%20want%20to%20search%20in%20another%20doc%20that%20has%20several%20columns.%20How%20can%20I%20filter%20a%20list%20into%20another%20doc%20so%20the%20items%20come%20up%20as%20well%20as%20other%20data%20related.%20first%20pic%20is%20the%20list%20I%20want%20to%20search%20and%20second%20pic%20is%20where%20I%20want%20to%20search%20it%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Alejandra_Rivera_0-1630006656039.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306082iC898152332FD62B3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Alejandra_Rivera_0-1630006656039.png%22%20alt%3D%22Alejandra_Rivera_0-1630006656039.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Alejandra_Rivera_1-1630006729662.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306083iECECF883C0CF46E7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Alejandra_Rivera_1-1630006729662.png%22%20alt%3D%22Alejandra_Rivera_1-1630006729662.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2689550%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2689566%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2689566%22%20slang%3D%22en-US%22%3Ehow%20do%20I%20do%20it%3F%3F%20pls%20help!!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2689651%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2689651%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1138777%22%20target%3D%22_blank%22%3E%40alexjaime%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20return%20filtered%20table%20by%20Power%20Query%20or%20as%20dynamic%20array%20using%20FILTER()%20function%20like%3C%2FP%3E%0A%3CP%3E%3DFILTER(Table%2C%20COUNTIF(Table%5BCategory%5D%2CList1))%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 

 

Alejandra_Rivera_0-1630006656039.png

Alejandra_Rivera_1-1630006729662.png

 

 

6 Replies
how do I do it?? pls help!!

@alexjaime 

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

@alexjaime 

Could you please provide sample file removing all sensitive and unnecessary information? It will be much easier to demonstrate formula on it.

HI@Sergei Baklan I actually was able to figure it out! thanks for the help 

@alexjaime , glad to know, thank you for the update.