get values of another sheet with a text value

Hi, heres my question,

I have a sheet with general analysis information, what i want to do is that when i write a "text value" in a cell of my row, it have to multiply currency numbers of another cell in that same row by currency data that would be in the same row of that "text value" in another sheet, for example.

I have a sheet where i write Pepe´s in my "restaurant column" / then i write 5 in my "# of bottles column" / i want to get a price in my " total column " that would multiply the 5 with the price that i have in the row of Pepe´s in the other sheet.

Heres a file to explain my self better

Restaurant Pricing.xlsx

Good day!
change the ranges to suit your table (if there would be additional)

Formula:

Please Login or Register  to view this content.

look attachment.

Restaurant Pricing.xlsx