I will try that, although the list is in order of the indicator, i.e. 1 through 7 in that order. I'm trying to find a place I can put the file that others can have access to it and see the equations/functions I used. Do you know any places where I could post this and send out a shortcut? I do have a Yahoo account, but don't know if they have that capability. (I'm a lot more comfortable with simple programming than I am with anything to do with the internet, other than e-mail and simple searches.) Warren
Anthony Chilco <[EMAIL PROTECTED]> wrote: 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 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]
