0 Replies Latest reply on Apr 27, 2015 12:56 AM by katielianne1402

    Tool to merge data dependent on column contents.. Data Merge or other?

    katielianne1402

      Hello,

       

      I'm in the process of producing a large catalogue in InDesign and have lots of tables containing descriptions, product codes and prices. I am looking for a way to fill in the price column automatically by referencing either the description or the product code columns (which are already filled in).

       

      E.g

      DescriptionProduct CodePrice
      Small123
      Medium234
      Large345
      XL456

       

      Is this possible to do with the data merge tool or is this a job for something else?

       

      I know that this is possible to do as i have heard of other companies doing this before.. unfortunately however this was something set up by a previous employee and they also now have no idea how to do it!

       

      Thanks in advance for any assistance.