I would like to creat a dynamic array (FILTER) based on the outcome of another FILTER, however, I get #N/A as result
I have two tables: Table1 (A2:C11 - columns Code1, Code2 and ItemCode) and table2 (A14:B30 - Columns ItemCode and description)
I have the FILTER function in cell E3 on table1, resulting in 4 values picked from column 3 (ItemCode) of table1
I have FILTER_2 in cell E15.
If I use FILTER(Table2;Table2[ItemCode]=E3;"No Match"), the resulting Array only gives me the outcome with the actual value of Cell E3
I would like to use the whole dynamic array in cell E3.
BUT
If I use FILTER(Table2;Table2[ItemCode]=E3#;"No Match"), the result is #N/A
Anyone an idea?
Please see enclosed file
Dynamic Array on dynamic array test.xlsx
Bookmarks