You are trying to add more IF Statements? The limit is Seven. After that
Excel will always return an error. You may want to Explore some other
functions.
VLOOKUP, INDEX, MATCH, OFFSET can sometimes be used to solve problems like
the one you are presenting, but you may have to redesign the worksheet.

tj

"spalmarez" wrote:


I have a dilema. I am trying to grab a date. Here are my columns, but I
have more than this:
START END START_1 END_1 START_2 END_2
23-Dec-04 17-Jan-05 25-Jan-05 15-Feb-05 23-Feb-05 16-Mar-05

Basically, I enter a date I want to look up and get the value, which
works for a few columns but not for 26 columns.

Here is my formula:
A4= 01/26/05 or any date


=IF(AND(A4=F4,A4<G4),"A",IF(AND(A4=H4,A4<I4),"B" ,IF(AND(A4=J4,A4<K4),"C",IF(AND(A4=L4,A4<M4),"D" ,IF(AND(A4=N4,A4<O4),"E",IF(AND(A4=P4,A4<Q4),"F" ,IF(AND(A4=R4,A4<S4),"G")))))))

But I get an error when I enter more in. Could anyone provide feedback
on this.
Basically I am looking for The Start date and End date between my
value. Any help would be appreciated or idea.


--
spalmarez
------------------------------------------------------------------------
spalmarez's Profile: http://www.excelforum.com/member.php...o&userid=15961
View this thread: http://www.excelforum.com/showthread...hreadid=274366