I’m working with a table that contains information about categories of products and oracle tables related with such products. Just like this:
I was trying to figure out how to extract in another location the tables used by each product using a dropdown list, for example:
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.
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.
Using INDEX/MATCH in the FILTER: