Hi,
If there is drop-down list containing various values, based on the value selected on the drop down list there should be a value which should be auto completed on another cell. I have seen many tutorials and they were all based on indirect function(where based on the selection made in the drop down list, few more selections appear in another drop-down). But i want the autocompleted value to be set by default along with the other regular depending cascading lists.
eg. cell A2 contains a list of book titles. when i select a book from A2, B2 should contain a default value of "xyz" which is common for all the books, c2 should contain another drop down which is relevent to the type of book selected from A2
Thanks.
Bookmarks