Google Sheets Drop Down List- Import Multiple Values?

I have a list of food with different columns (type of food, cost of item, amount per item, etc.). I know how to use data validation to create a drop down menu to select one column's worth, but what I'd like it to do is, when I select the type of food that the price of the food and the amount per item that... show more I have a list of food with different columns (type of food, cost of item, amount per item, etc.). I know how to use data validation to create a drop down menu to select one column's worth, but what I'd like it to do is, when I select the type of food that the price of the food and the amount per item that are on the right of the food item are also put to the right in other cells to the right of it. Basically, when I select a food from the list, it will import the other values from the cells to the right of it with it. I don't want to deal with coding or developer tools nor add-ons. Just purely built-in features. Any ideas?
0