update data based on choosen value from drop down list

[young_86]

hi,
I need to add:
1. drop down list which will show years. data(years) should be taken automatically from currency_price sheet.
2. after date and currency is choosen dates in column A should be updates. the same with currency price and currency roi. currency price value should be taken from currency_proce sheet, and currency roi from roi sheet.

I try few formulas which i know, but i failed. all support or advice is more than welcome
screen20191124.jpg

[Pepe Le Mokko]

Administrative Note:

Hi and welcome
although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
So, please update your profile to something more precise then "somewhere" ( country will suffice, no need to be more precise).
Thank you for helping us to help you

[JeteMc]

This proposal employs two helper columns added to the cuurency_price sheet. The first is to display the years using two formulas.
AN2 is populated using: =YEAR(MIN(A4:A624))
AN3:AN4 are populated using: =IF(OR(AN2="",SUM(AN2,1)>YEAR(MAX(A$4:A$624))),"",SUM(AN2,1))
A second helper column is added to identify dates of the selected year using: =YEAR(A4)=report!J$5
On the Report sheet cell J5 is populated using data validation with the source being: =cuurency_price!$AN$2:$AN$4
Cells A4:A255 are populated using: =IFERROR(INDEX(cuurency_price!A$4:A$624,AGGREGATE(15,6,(ROW(A$4:A$624)-ROW(A$3))/(cuurency_price!AM$4:AM$624=TRUE),ROWS(A$1:A1))),"")
Cells B4:B255 are populated using: =IF(A4="","",INDEX(cuurency_price!B$4:AL$624,MATCH(A4,cuurency_price!A$4:A$624,0),MATCH(B$3,Waluty,0)))
Cells C4:C255 are populated using: =IF(A4="","",INDEX(roi!B$4:AL$624,MATCH(A4,roi!A$4:A$624,0),MATCH(B$3,roi!B$1:AL$1,0)))
Let us know if you have any questions.

[young_86]

works perfectly. thank you!!!

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.