I used data validation on A2 Cell to take 1,2 and 3 from the table. Next, I have to use data validation again on B2 cell but this time, it has to be dynamic. For example, if I choose 2 on A2 cell, I can only choose ANDREA and FLISAT on B2 Cell.

Macro solution or excel function solutions are doesnt matter. Both acceptable. Thanks for help :)

File Formulas Developer Help Share Comments + Home Insert Page Layout Formulas Data Review View Le From Text/CSV Recent Sources Queries & Connections Pe From Web L Existing Connections Properties Refresh From Table/Range All Edit Links Get & Transform Data Queries & Connections & 21 22 ? Beclear HO al Group Ungroup Subtotal Get Data Stocks (En... Geography... - 21 Sort Filter Te Reapply Advanced - BO Text to Columns EDO Data Tools What If Forecast Analysis Sheet Data Types Sort & Filter Forecast Outline A2 fic 1 D G 1 J KL M N o R S A B 1 SEGMENT PRODUCT FIRST n MONTHS 2 11 F YEAR TOTAL SALES 2014 3 2015 4 1 2 3 SAMLA ANDREA DRAGON NORDEN FLISAT TARVA MULA 2016 2017 2018 2019 2020 5 6 7 8 9 10 11 Table 12 13 14 15 16 17 18 19 20 21 22 22 CUSTOMERS BRANCHES SEGMENTS PRODUCTS PRODUCT ANALYSIS RAW MATERIALS BOM SALES-SAMLA SALES-DRAGON II. + Ready EO 3 + %100