Catering excel file

[jturn]

I've created a catering file in Excel for our restaurant. Within this file I have 3 worksheets. The first worksheet is an items list that consist of 3 columns: item name, unit size, unit price. The 2nd worksheet is a form that contains info about the event including a table where we will enter the selected items from the first worksheet. I want this table to consist of 4 columns: amount, item name, unit price, extended price. I would like to have a drop down menu in each cell of "item name" column and have the associated unit price carry over as well. All this information will be linked into the 3rd worksheet which is a preformatted invoice. My challenge is getting the unit pricing to come over to the 2nd worksheet when selecting an item from the drop down list.

I appreciate any advice
jsturn

 

[jmthompson]

Sounds like you know how to do the drop down, so I will skip that.

Assuming Item is in column A and unit price in column C on your "List" tab and Item is in column B and price in column C on your Event tab.
Enter this formula in c2

=VLOOKUP(B2,List!$A:$C,3,False)

 

[jturn]

Thanks for your help. you saved me hours on this task.