Multiple conditions formula.....Challenge!!!

[Ajinkya]

Dear All,

Need your urgent help, I want date and location wise data for the models in given format. file is uploaded on following link.


Download link:

https://hotfile.com/dl/152390253/f7eb88f/Challenge.xlsx.html


Sheet2 contain data and result should comeout on sheet1.


Result should be like, if date is 03-Apr-12 and location is Hyd the model A, import=905, stock=1123,sale 1991 and Expected=543.


date and location are not fixed if these are changeed as per dropdown list output should be chnaged.

 

[vijaySharma]

@Ajinkya,


See if this helps...

https://docs.google.com/open?id=0BxRkrdCm95qbdUxKbVJlWEo1Unc


~VijaySharma

 

[Ajinkya]

Yup, Vijay, its works,thnx...

here i have again one minor requirement,


if im checking data for the 03-Apr-12 subsequently can we check only "sales" data for 05-Apr-12 (means 03-Apr-12 +2) in next coloumn. here +2 should be fixed and as per earlier date can not be fixed.


I think it also posible,thanks in advance dear...

 

[vijaySharma]

@Ajinkya,


File updated...

https://docs.google.com/open?id=0BxRkrdCm95qbSFhUcDNfTE9WaVE


I hope this is what you were looking for.


~VijaySharma

 

[Ajinkya]

Thnx vijay, this is working. once again thanks a lot dear