Forum Discussion
Menu Costing template
In the process of making a costing template for a new drinksmenu. Part 1 - Making a text cell represent a numerical value Need to create a template where I can make one cell with text equal anot...
Hi Hugh_Butler
I included another column [column M] to pull the Cost per ML (incl VAT) relating to each product using index and match.
=INDEX($B$2:$B$15,MATCH($K3,$A$2:$A$15,0))
Please see attached workbook and do let me know if any clarification is required.
Cheers,
Emmanuel