I am using OOo 2.0.3 running under Windows XP
In a Calc work book (is that what you call the three sheets tat appear by
default: sheet#1, sheet#2, sheet#3?) I have renamed sheet#1 as "Jobs" and
sheet#2 as "Invoices"
On the Jobs sheet I have:
---job numbers from 1-1000 in column A
---customer names in column B
---Invoice number (if there is one *) in column C
---and other data in columns D-H
(*) please note, the job numbers are in sequence but not every job has an
invoice associated with it. For example, the job might be to issue a quote,
and the quote is not accepted or proceeded with, therefore, no invoice.
On the Invoices sheet I have:
---Invoice numbers from 1200 - 2000 in column A (current invoice numbers)
---Job numbers in Column B
---Customer name in Column C
---and other data in columns E-H
To cut down on typing double entries I have used formulas in the Invoice
sheet to fill in the name and job number if the nvoice number exists in
sheet #1.
In other words, if in the Jobs Sheet I have:
Job W23 Kate Smith INV-1216
in the Invoice Sheet next to "1216" it will fill in the name and job number,
like this:
1216 W23 Kate Smith
NOW WE COME TO MY QUESTION !! - :o)
In the Jobs Sheet, if I make the text "1216" a hyperlink so that I can click
on it and bring up Invoice 1216 to have a look at, then all the information
next to 1216 in the Invoice Sheet disappears (ie "W23 Kate Smith"
disappears) ! ??
Is this because VLookup is looking for "1216" and the 1216-hyperlink is not
the same as the text or number "1216"?
If I substitute a simple formula such as:
Invoice.B23 = Jobs.A23
That works! It doesn't matter if Jobs.A23 is text, or a number, or a
hyperlink ... Invoice.B23 will show "1216" as its cell contents.
When I use =IF( ) or VLookup( ) functions is when it ceases to work.
Any help would be appreciated.
Many thanks, James
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
