Need Vloopkup Formula for Multiple Creteria + nested cells + multiply x between 2 dates

[kumar46]

Hi

Trying to create formula foe the below table which has multiple criteria x Qty x Duration (with two dates)

Attached sample file: Eg for Apple. Same as vlookup to be made for all items like carrot, beans, tv from nested cells.

After this, the results will be converted to Pivot table / chart.

Thanks for your support in advance!

 

[Special-K99]

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Make sure your data and formulas are clearly defined.

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.