If you have names, product IDs or some other words and need to translate those to number values you can do it with the IF, IFS, SWITCH or LOOKUP functions in Numbers. While the first functions are good for small limited lists of values, only the LOOKUP function works well with a large list that changes often.
Watch at MacMost.com /
Watch at YouTube