Dropdown to populate data from master sheet

I need some help with getting two dropdowns to populate data on my master sheert.

So I'd like to be able to select the Year then Month and the data populate for the date selected below. So I select 2019, then Sept, I would like to see the budget items for Sept 2019, and then if I select Oct, Items populate for Oct, and so forth. The data sheet has the due date (each item occures only once per month) and a makeshift calendar with "X" meaning the item has been paid.

All data is stored in the data sheet, but I don't know how to get it to work. It could be my layout is mess me up with figuring this out, but I am at a lose here. Any help would be greatly apperciated.

I can't get the arrays to paste and functions correctly. I end up with just the formulas you provided. Would you be able to modify the first attachment and repost? Maybe I can see where I am going wrong. Thanks again!

I guess it is a language related issue, so to get around it, I made your month list on column BC at Data tab with this formula:

Formula:

Please Login or Register  to view this content.

Please check attachment.

Awesome, thanks for the help. However, I think I didn't explain well what I was trying to achieve. The month and year selector (which I need to make prettier), I would like the Budget sheet to reflect the status of payment with the Data sheet and "X" markings. So if Terran has an "X" for Sep 2019 (S4 on the Data sheet) then on the Budget sheet when 2019 Sep is selected, the Bill Name, Amount and Due date are populated. Anyway we can get that to work? Again I really apperciate your help.

I understand you want to list only those rows marked with an X, so please try these array formulas. Make sure to array enter - after pasting, press Ctrl+Shift+Enter.
If you do it right, you'll see the formula inside curly braces { } in the formula bar.

Formula:

Please Login or Register  to view this content.

Change range accordingly for next two columns.

Formula:

Please Login or Register  to view this content.

Sweet! I have one last question for you, I'd like to add a scroll bar, could you assist in that? I expanded the data sheet to account for paid inidcator and amount (since that could change month to month). I tried to adjust for formula, but don't fully understand it. Would you please correct for me, that should be it after that. Thanks again.

You're welcome. I'm glad to help.

I made minor adjustments in the above formulas to accomodate the added columns in Data tab in those OFFSET/MATCH ranges.
Also, I put those formulas in the Data tab, and used your OFFSET formula to display results in your scroll bar range.

I hope it works.

Alright my friend, I need your assistance one last time for this. I was copy to copy and modify the formula for the "Investments" on the Data sheet, however, I can't seem to get the formula to populate the vaules from the "calandar" sections. Data tab HA2 is where the formula is and A101 is where the Names are and K100:AH125 is where the data is stored. Once I have "2019" coded right, I plan on expanding through 2025 (which I have is as easy as just copying the data calandar over. Again thank you so much for your help.

You're welcome.

You had misplaced the reference cell in the OFFSET function. Instead of I1, it should be I101 for the Investment data section.

Please check attachment.

Alright, I saw this addition that I'd like to make, and I have spent all night trying to figure this out. As you can tell I know nothing about arrays or how to reference them correctly. If you could and have a sec, this additional excel file has a "reminder" that I'd like to incorporate on the "register" sheet. I've done my best to try and copy and paste and modify the formula to reference my "data" sheet and associated fields, but no success. Would you kindly help, yet again?

I'm afraid you have now lost me completely.
I'll help you on if I can, no problem, but if your original question has been resolved, I guess you'd better mark this thread SOLVED and start a new one.

And when you do, please mock-up desired results manually.

My bad, created new thread: #post5200775

marking this as solved, thank you so much for your help.