possibility to tell Excel to calculate is a crucial feature
and the most important reason to use it. In other demos
Peter Kalmstrom has shown how to
create formulas for plus and minus and
how to make Excel multiply and divide.
In the demo below Peter shows how to use the Excel lookup
function and how to validate data so that users cannot enter
the wrong data in the sheet.
As an example Peter uses a calculation of prices for cargo
that is shipped in different ways. He has a list with the
cargo, the number of items to be shipped and the shipping
method, and he wants to see the costs for the various shipping
options in each case.
On a second sheet in the same workbook Peter has another
list with the costs for the different shipping options,
and in the demo he shows how to make Excel look up the cost
for the selected option in that list.
also shows how to validate the data, so that users cannot
write in an option that is not present in the list of shipping
costs. Instead they can select the options from a dropdown,
and should they still write in a non-existent value they
will get an error message explaining this.
Peter uses Excel 2013 for his demo, but the Excel lookup
function and data validation are the same for earlier versions