This is probably something very simple but I’ve tried multiple approaches and things aren’t working as I’d expect. I have 2 tables, Table 1 with some reference numbers on and Table 2 that is “looking up” those references and will eventually be populated with all the reference numbers as our project progresses. To keep track of progress I wanted to add a column to Table 1 that gives a simple True or False results if it finds the reference number from Table 1 in Table 2. I found it easy enough to do when checking a single column by using this formula:
If([UMPC / RSL 30-Week Plan].[RSL Grade 1].Contains(thisRow.[E&B Reference #]), “YES”, “NO”)
However we have 8 grades an therefore 8 columns to check against that are in Table 2. My question is how do I put that in a neat formula? I feel like I’m missing something blindingly obvious, which is probable lol.
Thanks in advance!