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]
