look Up Formula

[kme]

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.

 

[Juniad]

Paste the formula in cell N6 and Drag down.
=INDEX('Data-1'!$D$5:$O$51,MATCH(Answer!$N$3,'Data-1'!$C$5:$C$51,0),MATCH(Answer!$M6,'Data-1'!$D$4:$O$4,0))

Paste In cell O6 and drag down.
=INDEX('Data-2'!$D$5:$O$58,MATCH(Answer!$N$3,'Data-2'!$C$5:$C$58,0),MATCH(Answer!$M6,'Data-2'!$D$4:$O$4,0))

See the attached file.

 

[V_Agarwal]

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.

Formula at N6 =XLOOKUP($N$3,'Data-1'!$C:$C,XLOOKUP(Answer!$M6,'Data-1'!$C$4:$P$4,'Data-1'!$C:$P))
Formula at O6 =XLOOKUP($N$3,'Data-2'!$C:$C,XLOOKUP(Answer!$M6,'Data-2'!$C$4:$P$4,'Data-2'!$C:$P))

Both formulas are same, except sheet name..

 

[kme]

Thank you Very Much . Much Appreciate