Looking up data in tables II
Another useful application of the VLOOKUP function is when
using OpenOffice Calc to create invoices.
On one sheet - we have the catalog - where we can maintain the prices and the stock items in one location.
The VLOOKUP function comes into play on the invoice sheet - as is illustrated below. Here, the lookup table (the catalog) is on another sheet)
