Excel Lookup Function + Filtering/Displaying Data

My company has tasked me to come up with a solution that will allow our managers to select a food product from a drop-down menu, and have that product be displayed in a 8-up label format. The data will be stored on a different worksheet, but in the same workbook, and protected so people cannot edit/change it OTHER THAN the price for the food product.

Example:
Item..........................Ingredients......Allergens......Calories......Price
Apple Pie (Slice)........Some Stuff......Not Many.....Lots............$3.25
Delicious Cookie......Some Stuff......Not Many.....Lots............$1.50
Warm Brownie...........Some Stuff......Not Many.....Lots............$1.25

Data such as the above will be provided and placed into Worksheet B. In Worksheet A, there will be a simple drop-down list at the top center where the user can select the "Item". Once selected, the item will be displayed below the drop-down list a total of 8 times, in a formatted layout so the sheet can then be printed onto label stock - the key here is that the ingredients, allergens, calories and price also need to be displayed at the same time.

I have the data already entered, and I'm ready to proceed to the Lookup step... at least I think? I'm not even sure if I need a Lookup, or something else!?! This is beyond my scope of Excel knowledge (I'm a graphic artist... give me a break) and so I turn to the community for help.

Hi and welcome to the board

For printing labels, I would suggest you use Word item " Envelopes and Labels" and you base the data on your worksheet

I don't have Word 2003 right here, but XL help will surely guide you

I'm already using the Mail Merge function with great success. However, it's been determined that many of our employees (Chefs, Cooks, etc.) lack the technical aptitude to properly use the system.

This must be done entirely in Excel. Further, as stated above, it's not a data entry solution - the user will simply pick from a drop-down list and it will put all the data where it should be.

You can find some examples of data entry forms here