« Looking Up Data In tables I | Main | Looking up Data in Tables III »
September 14, 2004
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)
Posted by Dave at September 14, 2004 07:07 AM