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

    use vlookup to Excel


      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,