Forum Discussion
Return multiple match function
Hi, I am building a taxonomy in excel for a financial product to define their metrics. It is similar to providing all options in a school library catalogue based on your filter. - I have 3 hea...
A Power Query solution attached. I had to remove some extra spaces :(( in the below columns:
Thanks for the response Lz. But i am a little confused. How the response change based on the drop down in sheet 2? Can you please elaborate, and give me some key steps to repeat the process?
You can forget/delete Sheet2. I created it just to copy/paste your expected result when 'User Experience' is selected in Sheet1 B7 (allowed me to compare what you expect and what the query returns)
How to:
- Select either Business or User Experience in Sheet1 B7
- Right-click somewhere in the blue Table under QueryResult > Refresh
Note:
The 1st query Refresh within an Excel session takes more time (to load the .Net Framework) than the next Refreshes