My skills have deserted me...
I want to create a spreadsheet which lets me do this:
I have three sets of data, lets say companies, subsidiaries, and then comments. How can I get it so that I can make a drop down list for companies and subsidiaries so that, when I select it, the corresponding company/comment shows up as well and not just the thing in the list. Is this something for a list? Is there something else I can do?