How to line up information in columns

Hi all,

I need help aligning columns. So i have attached an example workbook for the scenario.

On sheet1, i have all the items that we sell (Menu Item) in column A, the (Sales Category) in column B and the (Quantity Sold) in column C.

On sheet2 and sheet3 i have sales from individual days that i want to line up with sheet1 so that i can calculate an average of what we sold. The thing is that on each day (sheet2 and sheet3) we dont always sell each item, so the items dont line up. I started copying and pasting and then manually moved rows down so that they line up. It didnt take me long to realise that it will take forever to do it that way, so here i am looking for assistance.

Note that i do need all the columns to line up, so that i can see the Menu Item, Sales Category and Quantity Sold for each product. (example of what i need in sheet4)

Calculating the average is the easy part for me, its the aligning of the 3 columns is what i need help with.

Thanks

This is so much better than the way i wanted to do it.

I have a question though. so if i type =VLOOKUP(A2,Sheet2!A2:C232,3,FALSE) for my first entry, i now want to copy that formula down for all 200 rows, but when i do that, it changes the Table Array for each row. i need it to change the lookup value as i go down each row so that it looks for the next product but it must always look at the same table array. Please help

Sorted, dem $$$$ signs

Awesome thanks,

One last question, so now each lookup value that doesnt have a value ends up showing #N/A, how do i get it to replace that with 0