Show data based from selected parameters in drop down

Hello All

Need your help to Show data based from selected parameters in the drop down.

Also, for example, if the selected month is MARCH, it will add up all the month from jan-mar.

Excel file attached.

Thanks.

Hi novena,

welcome to the forum.

Try using below formula:-

Formula:

Please Login or Register  to view this content.

see attached:-
Dropdown.xlsx

Regards,
DILIPandey
<click on below * if this helps>

Why there is a differentiated naming in data like Product# and Brand#? why the text identifier is not unique?

Hi and welcome to the forum

try this option.

1. give each month-table a range name that matches the month (January_2013 = A1:K14 etc)
2. give each set of row headings for each month a range name that matches the month, and add a C (January_2013C = A1:A14)
3. On sheet1 change the names from Product1 etc to Brand1 etc....also remove the trailing space on sheet2 in B1
4. them on sheet1 B6, copied down, use this...
=INDEX(INDIRECT(SUBSTITUTE($C$2," ","_")),MATCH(A6,INDIRECT(SUBSTITUTE($C$2," ","_")&"C"),0),MATCH($C$3,SOURCE!$A$1:$K$1,0))

On a side note...it is really important that you use consistency in your headings, else formulas like this 1 will not work
Also, if at all possible, avoid the use of merged cells, thet create havoc with formulas

Hope this helped

lol gotta love it when they change the goal-posts

Hi Novena,

Suggest you to change the layout of your data, transferring everything in columns like : Month-Year, Brand, Branches (Hotels), Sales and then you can try pivot table.

Regards,
DILIPandey
<click on below * if this helps>

A suggestion might be to have separate columns for each month (you can hide them if you want), and then have a YTD total, based on those columns?

In B6 cell of Sheet1

Formula:

Please Login or Register  to view this content.

Drag it down........

In B1 cell of source sheet there is an extra space in Branch1 data.

Please dont ask me to do editing work in the above formula my mind will get collapsed