I am trying to combine two data source where the “match” value is the only value in its field in one table and is contained in a list in the other table. In my example, Table 1 has each fruit listed individually, and table two has a field for the expiration date, and a field that lists all fruit with that expiration date. Ultimately I would like a list of all fruit, its price, and its expiration date
I tried the approach in Find keywords in text (from a large list), but if I’m understanding it correctly, then that won’t work for my scenario since not all fruit has an expiration date, and therefore any fruit that is missing that value would get filtered out of the results completely. Am I understanding that correctly? If so, do you have any recommendations for reaching the desired result in the screenshot?