Hi I hope you can help as this is driving me crazy 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.

Index, Look up, Match Q

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

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.

Last edited: Aug 4, 2017