Dynamically select column from excel

[sahasanb]

Please help me solve this issue
I want to Dynamically select column from attached excel  where  Price Group,,Product,NDC is fixed by remaining column like 1Q2021 IR

or 1Q2022 IR or 4Q2022 IR
NDC #

Price Group
Product
NDC #
1Q2021 IR
2Q2021 IR
3Q2021 IR
4Q2021 IR

[Luke_C]

Hi @sahasanb 

Have you looked at the dynamic select tool? You can write a formula to determine which columns you'd like.

[binu_acs]

@sahasanb as @Luke_C mentioned this can be done with the help of the dynamic select tool