I would think this is easy but can’t figure it out. Anybody know the formula?
Table 1 is a list of prospects and who referred those prospects.
Table 2 is a list of customers
Column 2 in table 2 shows all the prospects that the customer referred by a simple lookup formula.
What I need to do it is filter that lookup list to only show all the prospects that are also in the customer list and therefore they are no longer prospect, but the have become customers.
Is there an easy way to do this with a filter formula?