Let’s say I have two tables in a workspace.
Table 1 has two columns. The first column is a list of vendors. The second column is a checkbox used to indicate whether the supplier is in-state.
Table 2 has two columns. The first column is a list of buyers. The second column is linked to Table 1’s vendors, and shows for each buyer which vendor or vendors they do business with. (Some buyers might do business with only one vendor, while some buyers might do business with multiple vendors.)
What I’d like to do is add a third column to Table 2, which indicates whether one or more of the vendors a buyer is doing business with is in-state, per the second column in Table 1. What formula or other method would I use to accomplish this?