0 Replies Latest reply on Jul 6, 2016 5:36 AM by FransM

    use vlookup to Excel

    FransM

      I have an Excel sheet with 3 columns:

      ArticleCode     Description          Price

      A123               Hat                         12,30

      B456               Bike                      125,00

       

      Now I want to link it to InDesign.

      I want to create a textbox with a sort of formula, like: vertical lookup("A123",column 2) --> "Hat"

      Connecting to a database (Access/SQL server) is also a possibility.

       

      Mailmerge is not the thing I mean, since I have list of thousands of rows and I need to place the right article on the right place in InDesign.

      For example: 10 articles on page 1, and 6 on page 2.

       

      Is there a way to achieve this (haven't found it so far)?

       

      Thanks in advance,

      Frans