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,
Retrieving data ...