Match and Sum

[kme]

Answer Required Through Excel Formula in Sheet1 and Sheet2

Sheet 1"Summary Division" Colum B4 Drop Down Given
Sheet 2"Summary Branch" Colum B4 Drop Down Given

Sample Answer Give Yellow Higlighted

If Drop Down List Change Then Concerned Branch Or Division Sales And Profit Data Pick From Data Sheet as Prescribed Format

Data Sheet "Colum A" Mentioned Division Names
These are the Data Sheet
Sales 2021
Sales 2022
Sales 2023
profit 2021
profit 2022
profit 2023

 

[p45cal]

Very hard work with formulas.
Easier with tables, Power Query and Pivot tables.
See attached.

 

[kme]

Can Create Formula !. If we Better For Us

 

[p45cal]

Someone else may chip in…

 

[kme]

pls Can Create a Formula !

 

[kme]

Pls any one Can Croat a formula!!!

 

[kme]

Pls any one Can Create a formula!!!

 

[vletm]

kme​

Where are Your Sample Answer Give Yellow Higlighted ?

 

[kme]

Dear Sir
File attached
In Sheet -"Summary Division" & "Summary Branch" Sample Answer Given


Division Need to Pick from Data Sheet "Colum A"

 

[vletm]

kme​

Can You send a raw data, which You've used to get those Sales & profit sheets?
Those looks like Pivot-tables.

 

[kme]

Dear Sir
Sample Answer In Summary "Branch Sheet" Which Where Picked from Data Sheet mentioned .

 

[vletm]

kme​

Did You skip to read #10 Reply?
You replied again to my #8 Question.
Without Your answer - You'll be without my possible formula solution.

Here other kind of sample.

 

[kme]

#10 Reply- Dear Sir

The data in the data sheet is taken from our software so it looks like a pivot table

 

[vletm]

kme​

... then those sheets should have same layout - - there are differences.
You can use ... #12 sample ... with minor modification those differences.

 

[kme]

#12- There is no Excel Formula in Excel Sheet. Can Share Formula

 

[vletm]

kme​

As written in #14
... means won't share formula.