I´m trying to use the filter function using a range of different criterias to match.

I want Return Table 2 SKU ID for all cases where Article ID is a match with Article ID in Table 1.

Using =Filter(Table2[SKU ID],Table2[Article ID]=Table1[Article ID]) just gives me an #N/A error. How can I do this?


Data in table 1
Article ID
30704
29116
30703
30702

Data in Table 2
SKU ID Product ID Article ID
151208 10203 29116
151209 10203 29116
161192 10203 30702
161193 10203 30703
161194 10203 30704
161195 10203 30705