Replied to
Reference columns vs lookup columns — when to use which?
Use Reference columns for stable relationships (e.g., product name from product ID). Use formula-based lookup for derived values (e.g., price × quantity from the rate table) where you also want to apply a transformation.
