I changed the LOOKUP() function in columns D and E to be a VLOOKUP() with
the fourth parameter set to 0 so the function looks for an exact match. The
LOOKUP() function requires that the lookup vector be ordered. Since column
A of the Database sheet is not ordered, incorrect results were returned.
I
Hi Archie,
Welcome to OpenOffice. I whish you a lot of fun with the Software.
There are lots of possible ways to make your live easier.
I would recommend to use our forums or users mailing list to ask
questions on ways what you want to do.
I think there are all the features you do expect, b