On Wed, 2 Nov 2005 18:50:01 -0800, "L@FUTUREALL"
wrote:

THANK YOU SO MUCH FOR ANSWERING ME BUT IT DID NOT WORK I THOUGHT THAT I WOULD
NEED TO START OUT USING AN IF FUNCTION AND NEST A V LOOKUP WITHIN THAT?

If it's not working there is something else wrong with your formula, or with
your implementation of my suggestion.

(dtDATE(2005,9,20))+1 will return a 1 if date is <=9/20/2005 and a 2 if dt is
9/2/2005. It is in the section of the formula that pertains to column number.

That is what I understood you to want -- change the column number depending on
the relation of date to 20 Sep 2005. Did I misunderstand that specification?

There are certainly many different ways of constructing a formula to obtain the
same result. And it could be done with IF functions. However, since you chose
to not post your formula or your data, or how you integrated my suggestion into
your formula, or what the results were of that formula, it is not possible for
me to troubleshoot.


--ron