Hello everybody and thank you for reading this,
I am currently working with Excel and trying to make a sheet that fills itself out. I have a dropdown list that lets you choose an item then in the cells to the right I am trying to display information about the item ie: calories, grams of sugar, description etc. I have all the data typed out in cells on the second sheet so I want people to be able to, only accessing the first sheet, to be able to choose and item and have the data displayed for them without them having to search through a database.