First, we set our data up so that the items on the menu are in Column A and the price for each item is in Column B.This can be achieved by using a locked VLOOKUP table array.
In this example the owner of Icy Treats wants to quickly know the total sales for the day. This tutorial will give you step by step instructions on how to lock the VLOOKUP tableįinal formula: =VLOOKUP(D3,$A$3:$B$11,2,FALSE) Setting up the Data By Locking the VLOOKUP from a table array, we can quickly reference a set of data against multiple lookup values.
