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

kumar46

New Member
Joined
Feb 15, 2018
Messages
1
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!
 

Forum statistics

Threads
1,085,566
Messages
5,384,476
Members
401,904
Latest member
markschneider89

Some videos you may like

This Week's Hot Topics

Top