A filter formula is driving me nuts

2

Hey @Pilar_Azagra
Your filter formula is just fine (although you don’t need the ToText part), the problem is that the names in table 1 starts with blank space so it’s different from the names in table 2 and therefore don’t get filtered correctly.

About the filter vs. lookup issue, see this post:

2 Likes