Forum Discussion
#Dynamic Data Validation, Indirect, Offset# anyone can help?
I used INDIRECT to get a list for Data Validation, but the result is totally different in these 2 scenarios. Scenario 1: use offset to get a dinamic range, the result is error. Scenario 2...
thank you so much for your time.
I revised the OFFSET formula and it referred to the right cells.
after that, i use INDIRECT in the data validation, the result is still the same.
I revised the OFFSET formula and it referred to the right cells.
after that, i use INDIRECT in the data validation, the result is still the same.
- thank you so much. but it's really hard for me to understand even though I've spent a few hours on it.