This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have Table1, with [IDNum] as a key, [Label1] as the ticked label column, and [Label2] as an alternative label to be used in specific cases.
In another Table2, the column [EntriesFromTable1] of type Ref, has the formula =Table1[IDNum] in suggested values and it works fine by listing all entries with the labels in Table1[Label1] (the ticked Label)
In a Third Table3, i want to do the same as in the previous, but i want the produced list to be labeled based on Table1[Label2]