Hello,

I have a COMPLETE list of my inventory with it's corresponding cost (Column A: Item Name; Column B: Price of Item)

I also have daily lists of sold items which varies from day to day.

I am trying to do the following:

Paste the list of items sold into a new sheet and have their corresponding cost of each item sold show up next to each item. I am very new to excel and I would really appreciate someone helping me with this issue. Since I spend 2 hours daily inputting all the information one by one.