Hi All,

Im trying to do something in creator that is very easy in Excel but not sure if I will be able to recreate the functionality.

I have a report which stores lots of different values against a unique product number. One of the fields is 'language code' which is a number and the other is 'language', a multiselect with a list of languages.

The languages assigned to a given language code can change so my plan was to have a master report with just these two columns so that if i change the language field for a given language code, it automatically updates all the product numbers with that particular language code.

Will this be possible in creator? In excel you would just have two sheets/workbooks and a single Vlookup expression. I've already noticed that lookup fields are not able to reference multi-select fields so this may one limitiation.

Thanks in advance!