1 Reply Latest reply on Aug 15, 2016 5:31 PM by Yuriy Fal

    Lookup based on multiple columns (some calculated)?

    Samuel Gold

      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:

       

      13664600_1238828626136929_1962288906_n.png

       

      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!