1. In The 1st Sheet "Data-1" Branch Wise & Division Wise Sales Details . 2nd Sheet "Data-2" Profit Details, In this 2 Files Look Up Traget Value (Sales and Profit) As per the Branch and Division
2. if Division in "N3" Select .Then Automatically Coming against the Branch. Division Target figure should appear
3."N3"- There is Drop Down List .If the Division Select Through Drop Down List. Then Automatically Came against The Branch and Division Target. Look Up From "Data- 1","Data-2"
4. Sample Answer Table Given Left Side.
5. Need Formula.
2. if Division in "N3" Select .Then Automatically Coming against the Branch. Division Target figure should appear
3."N3"- There is Drop Down List .If the Division Select Through Drop Down List. Then Automatically Came against The Branch and Division Target. Look Up From "Data- 1","Data-2"
4. Sample Answer Table Given Left Side.
5. Need Formula.