• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Match and Sum

K

kme

Member
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
 

Attachments

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


Division Need to Pick from Data Sheet "Colum A"

1736589105940.png
 

Attachments

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.
 

Attachments

Last edited:
#10 Reply- Dear Sir

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

kme​

... then those sheets should have same layout - - there are differences.
You can use ... #12 sample ... with minor modification those differences.
 
You must log in or register to reply here.
Back
Top