James Lockie wrote:
I want to use the all a value to the cell returned by lookup.
Basically I have a sorted column (A) that contains categories and
column B which contains a number.
I also have another 2 columns (C, D) that contain a category and a a
number.
I want to add all the numbers that are in a specific category.
What I doing is using the lookup function to return the value in
column B of the category where A=C.
I need the cell in column B so I can add the value in column D to the
value in column B.
I believe that the answer is yes, but you might need to work a bit to
extract exactly what you want.
I documented this in "Calc as a simple database". It is on my web site
(the database page) and more recently it has been modified into the
official documentation
http://documentation.openoffice.org/manuals/oooauthors2/index.html
Download chapter 13 of the calc guide. Look for the section on Match and
following. This is after VLookup and HLookup.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]