Hi Warren,
Most attachments don't make it through to the list. I can take a guess
that you need to add a fourth parameter to your vlookup function. This
one tells the function that the list is not sorted. The default is a
sorted list.
= vlookup(a1;b5:c55;2,false)
If this is not the problem, paste the formalae that you're using into
your reply.
tc
You appear not to be subscribed to the users' mailing list. You could
miss many of the replies to your post unless you do subscribe. Just
send a blank message addressed to <[EMAIL PROTECTED]> using
the e-mail account through which you want to receive it. You will
receive a message asking you to confirm your subscription by replying to
it. See http://support.openoffice.org/index.html for more options.
Subscribing is optional. Be aware that after subscribing, you may
receive many messages from the list. Be prepared to set up mail filters
in your email client in order to deal with them.
Warren Griffin wrote:
The problem is explained in the first sheet of the attached file, but I
have included a brief description below.
I am using a lookup table in one sheet in a logical statement in the
next sheet. The logical statement uses a value from the first sheet and
the lookup table to find a day of the week to check against a day of the
week in the second sheet. If they match, it assigns the value 1 to the
cell. I can see the value on the first sheet corresponding to a
particular day of the week and yet the lookup table returns the previous
day (as though the index number had been decreased by 1). This doesn't
happen for any particular day of the week, or sequence of days of the
week, as near as I can tell.
Any ideas?
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
