Forum Discussion
jontko
Dec 06, 2021Copper Contributor
Pivot Table search by one term in a cell with multiple terms.
Hello there, I am using a Lenovo P1 and working in Office 365 Apps for Enterprise Excel version 2110 (Build 14527.20276), I'm building a workbook to track Bill of Materials for industrial automatio...
Riny_van_Eekelen
Dec 15, 2021Platinum Contributor
jontko Perhaps Power Query is something for you. Attached an example based on the data you provided. Type the location C14 (not case sensitive) and press Refresh All on the Data Ribbon. Then the green table should reflect the selected location instantly.