excel - Change sheet source dynamically

Question

How to change Excel sheet source dynamically depending on particular values? I am developing an Excel sheet. Depending on one dropdown value, fields of other dropdown should change dynamically.

Suppose I choose one value from dropdown1, dropdown2 should get certain column from "Sheet2" and if I choose another value from dropdown1, dropdown2 should get certain column from suppose "Sheet".

How can I achieve this?

This should be related to Excel formulas I guess.

Answer 1

Just follow this tutorial

1. Create lists
2. Give lists a name
3. Use data validation to create dropdown
4. Use indirect when creating new data validation