Hello,
I'm trying to figure out what function (or set of) would be best for my task. I need to create a spreadsheet with minimal user-input. Column A will have a list box via data verification and everything else will be locked and filled in through functions by taking data from another sheet. I've created an example of what I'm trying to accomplish and it's attached.
The user will select an option in column A, here "Drinks." Doing so will fill in the data in the columns to the right automatically. My list options in the final document will be fairly extensive, so using IF statements might get pretty crazy. I'm sure there is a more efficient way to handle this. I'm thinking VLookup might be my best route?
Thanks for your time!
Bookmarks