A B C D E F/result
1 27 17 Oct 25, 2007 Oct 4, 2007 Oct 4, 2007
1 27 1 Oct 4, 2007 Oct 11, 2007 FALSE
1 27 21 Oct 25, 2007 Oct 25, 2007 Oct 25, 2007
1 27 5 Oct 18, 2007 FALSE

the picture of the table which was mentioned in the below/previos mail is
not in a good format. so please consider the above one.








"surya and siva" wrote:



hi friend,
here i just want a comparision, if the criteria matches i want the same date
to be reflected. here is the senario.
A B C D
E F(result)
1 27 17 Oct 25, 2007 Oct 4, 2007 Oct 4, 2007
1 27 1 Oct 4, 2007 Oct 11, 2007
1 27 21 Oct 25, 2007 Oct 25, 2007 Oct 25, 2007
1 27 5 Oct 18, 2007
so IF A=1, and B=27 then E date should match with D date, if matches i want
that date should be reflected in F coumn.
like this there are n number of Categories are dere in A collum Eg:
1,2,3,4,5,....so on and each Category contains sub-category...so please give
a formula which can be applicable to all. Please help me out as soon as
possible.
thanking you.
surya