Is it possible in excel to have a cell value automatically inserted once the previous cell has been inserted, where the previous cell has a direct relationship to this one which is defined in another table.
For example: on the first worksheet there is 2 columns: 'isbn' and 'book title', on another worksheet there is a table containing isbn values and there corresponding book titles. On the first worksheet the isbn column is a drop down that lists the isbn's from the table on worksheet2.
When the user selects a isbn from the dropdown i would like the book title column to be filled in automatically with the corresponding title from worksheet2 table.
