I have created drop down lists, now I want to display list of values in the cells corresponding to the option selected from the second drop down list. How do I do this?
When I tried index and indirect function I got an error message and I dint know how to resolve it.
I would appreciate any suggestions on how to address this. The file is attached and the values I need in sheet 1 are highlighted and the source values are in sheet 2.
Thanks!
Bookmarks