On Wed, 2 Nov 2005 19:06:01 -0800, "L@FUTUREALL"
wrote:

THIS IS THE FORMULA I USED AND IS WORKING TO A POINT

=IF(G4<9/18/2005,VLOOKUP(F4,RATE,2),VLOOKUP(F4,RATE,3))

G4 IS THE DATE, THE COLUMN THE DATE IS IN

F4 IS THE EMPLOYEE CLOCK #, ITS LOOKING UP FOR THE RATE INFO

RATE IS THE DEFINED AREA THAT I SET

2 IS THE COLUMN IT LOOKS THE RATE UP IN

OK JUST SO YOU GET AN IDEA OF WHAT I AM DOING

SO WHAT IS HAPPENING IS THATTHE IF STATEMENT DETERMINES IF THE ARGUMENT IS
TRUE OR FALSE AND THEN IT SHOULD LOOK UP THE RATE IN THE LOOKUP COLUMNS, IT
DOES THAT, BUT THEN I PASTE MY FORMULA DOWN THRU MY SHEET, AND IT IS SAYING
TRUE FOR A FALSE STATEMENT, IF YOU CAN UNDERSTAND WHAT I AM SAYING, LOL

THANK-YOU FOR ANY HELP ON THIS, IT HAS BEEN DRIVING ME NUTS FOR WEEKS!



Your IF statement is not working because 9/18/2005 is not being interpreted as
a date; but rather as =9/18/2005 -- 0.000249377. Since the contents of G4
will always be greater than that number, the IF will always evaluate to TRUE.
To use dates in an unambiguous method, either use the DATE function as I did in
my suggestion, or enter the date in some cell and reference that cell.

I would still suggest:

=VLOOKUP(F4,RATE,(G4=DATE(2005,9,18))+2)

as being simpler. Since it is now apparent that you want either column 2 or
column 3, I am adding two instead of 1 to the equality in the "column_number"
argument so as to obtain the correct numbers.

If you really, really want to use your IF statement, then try:

=IF(G4<DATE(2005,9,18),VLOOKUP(F4,RATE,2),VLOOKUP( F4,RATE,3))





--ron