I have two files-- one contains a list of ordered products, and the other is a list price sheet. I'm trying to link the products ordered to their list prices. The list price sheet looks like this:
The ordered products file contains columns for size, year, and type, as well as many other columns (type is a calculated field.) How can I create a calculated field in this ordered products file that looks up the price (based on type, size, and year) from the list prices sheet? Thanks in advance for any help!