Find the last price of a product sold

Hello, thanks for your quick response but I am still struggling with the real spreadsheet. My problem is that the item names are not always exactly the same, so It needs to be something like "if this part of the tittle of the item is equal to" then find me the last price. Also, the cells are in different sheets and I would like to ask for the whole column.

I am attaching a smaller spreadsheet, the one I'm working is too big

I hope the spreadsheet helps