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