Hi Robin
You are correct when you say that I would be better off using a database application and I have started to do that, building my tables, forms, queries and reports in Access. However, trying to use Calc has provided me with a great learning exercise and a better appreciation of some of the things that Calc can do, so the effort was not entirely wasted, and most of the data can be imported into my new Access tables.
I am only using Access because I know it, having learned it during my Uni course. I would prefer to use a non-M$ application if I can. Are there any tutorials about MySQL or other free source applications on the Internet, and is it hard to learn, given that I have already studied database theory in general and Access and Oracle?
Many thanks, James Elliott
----- Original Message ----- From: "Robin Laing" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, February 25, 2005 4:37 AM
Subject: Re: [users] Calc challenge.?
James Elliott wrote:I am using VLOOKUP a lot to copy the fields from a "Jobs" spreadsheet, to a "Service Report" spreadsheet. In other words, when I am doing a report, instead of typing in all the customer details, etc, again, as soon as I enter the Job Number in the appropriate cell, most of the remaining cells are filled in by VLOOKUP.
My columns in the Jobs spreadsheet are labelled: DATE JOB No. CUST No. CUST NAME TRAVEL TECH TIME FREIGHT etc.
If I use JOB No. as the search criterion, then I can use VLOOKUP to find: CUST No. in column 2 CUST NAME in column 3 TRAVEL in column 4 .... and so on ...
But ... how do I find the DATE which is in the column to the left of my search matrix?
By the way, it seems that the Search Criterion has to be in column 1 of your search matrix for VLOOKUP to find it, so I can't unclude the DATE column in my matrix.
Many thanks, James Elliott
This sounds more like you need to use a database, not calc.
-- Robin Laing
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 22/02/2005
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
