Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

EXCEL: How to extract a subarray from a column based on the values of another column?

I’m working with a table that contains information about categories of products and oracle tables related with such products. Just like this:

Table with info of different products

I was trying to figure out how to extract in another location the tables used by each product using a dropdown list, for example:

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

If any of the product is selected from the dropdown list the tables marked by an X in the previous table must be shown as in the red square.
Expected result

I was trying using INDEX, XLOOKUP, FILTER and combination of them unsuccessfully

Somebody can help me to figure out how to obtain the desired result?

Thanks in advance.

>Solution :

Using INDEX/MATCH in the FILTER:

=FILTER(Table1[TABLE],INDEX(Table1[#Data],0,MATCH(H2,Table1[#Headers],0))="x")
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading