Is it possible to correlate data from multiple worksheets ?

[alexandre-ava]

I'm quite amazed by how the code become simple using templates. However, I'm not sur this library can handle my use case.

I have a sheet "Quotation" that contains quotation lines and another sheet "Catalog" that contains products with their prices. In a column of my "Quotation" sheet, for each quotation line I will have a refrence to the cell containing the price of the corresponding product in the "Catalog" sheet. I'm wondering if there is a mechanism to do that using ClosedXML.Report.

Here is what I mean:

The quotations lines don't have to be in the same order than the products in the catalog.

So I don't know if I will be able to correlate the quotation lines with the associated products using ClosedXML.Report. Any idea if it's possible?

[alexandre-ava]

I'm thinking about assigning names to all the prices in my worksheet Catalog ("Product1" for cell B1 for instance) and use the INDEX function to retrieve them in my worktheet Quotation ("=INDEX("Product1";1)" in H3 for instance). I don't know if it's a good idea and I don't know if assigning range names can be done using ClosedXml.Report.