Hi All,

DrawLoop uses an excel template in Salesforce to generate documents from Order record. When running a DDP that uses row replication in Excel for line items, I have used Excel functions to calculate values for few columns. Used Vlookup function to search certain value from dynamical data(row replicated table array), but it is not working as expected.

I have tried multiple ways of selecting table array while applying Vlookup, by selecting a range of cells for the data, and selecting the top row of the table (which shows cells with start tag), but it is not working at the moment.

Any help would be appreciated. Thanks in advance!