How to populate multiple columns with a single dropdown selection
Tracking a bunch of different reports on a spreadsheet, blah blah blah.
My boss has asked me to put additional info on the spreadsheet. His suggestion was to use lots and lots of columns, which offends my delicate sensibilities.
The attached sheet will let you see the problem more clearly. on sheet 2, I have a 3 column list.
on sheet two, those three columns are in the middle of the spreadsheet. Right now, I have a drop down that allows me to select an option for the Column A. What I would like is to be able to select an item for Column A, and have the spreadsheet populate columns A, B, and C based on the list on sheet 2.
Can that be done? If so, how?
Thanks
|