Dear,
I want to display the lookup values of a 15k value column, based on multiple criteria.
The amount of criteria can range between 2 and let's say 5 to 10 (max).
The issue is that I don't need the array of the location where A=B, but I need the result of the index match search in the column next to it.
Let's assume the following list. I want a list the displays AX followed by AD when I select items (criteria's) B + C.
Item / parent item
A / D01
B / AX
C / AX
D / C01
E / EF
B / AD
C / AD
The idea is to track in which assembly the items are used.
Can someone help me?I've managed to show the individual results, but not to combine them.
All help is appreciated
I want to display the lookup values of a 15k value column, based on multiple criteria.
The amount of criteria can range between 2 and let's say 5 to 10 (max).
The issue is that I don't need the array of the location where A=B, but I need the result of the index match search in the column next to it.
Let's assume the following list. I want a list the displays AX followed by AD when I select items (criteria's) B + C.
Item / parent item
A / D01
B / AX
C / AX
D / C01
E / EF
B / AD
C / AD
The idea is to track in which assembly the items are used.
Can someone help me?I've managed to show the individual results, but not to combine them.
All help is appreciated