Index, Look up, Match Q

[k8bug79]

Hi I hope you can help as this is driving me crazy


[TABLE="width: 401"]
<tbody>[TR]
[TD="colspan: 2"]https://1drv.ms/i/s!AltSK4V_VD03iGo9OswyEYs850Ib

Above is a link to a screenshot of part of my worksheet.


I am trying to calculate the total cost of beverages bought for a till type sheet.

So The drinks are populated from named fields- I type =Chardonnay and up pops "James Estate Chardonnay"

I ten drop down the unit- Bottle/ Glass and complete the number of items they bought.

So I am trying to say lookup the wine in the beverages table (which I have built on a back sheet and named -Beverage) and match it with the unit (bottle) to return the price in the beverage table. Which is laid out like

https://1drv.ms/i/s!AltSK4V_VD03iGo9OswyEYs850Ib

However I want it to be blank when nothing has been populated in the drinks name or quantity,

Further up I have it working for food- but this does't require the extra step of serving size.

Can anyone help please? I am desperate to get this sheet working for tomorrow.[/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]