Condition fixed for text between two dates

[Vandini.S]

Sir,

if end date are covered form 02.03.2015 to 05.03.2015 the value return is Meeting01. In-case Start date(05.03.2015) end date are covered next meeting from

Meeting02 to Meeting05 the value return is 0.Start Date(A) End date(B) date are covered next month the value return is "Data Not Available form the table".

if end end date are back date value return is "Check Entry".(Start Date 31.03.2015 but End Date is 28/03/2015).

please help me.file attached.

[Vandini.S]

Sir.

sorry previous thread data not mentioned.

Data:

Date Text
01/03/2015 Meeting01
02/03/2015 Meeting01
03/03/2015 Meeting01
04/03/2015 Meeting01
05/03/2015 Meeting01
06/03/2015 Meeting02

Required Format:

Start Date End Date Desired Results
01/03/2015 01/03/2015 Meeting01
02/03/2015 02/03/2015 Meeting01
02/03/2015 02/03/2015 Meeting01
03/03/2015 03/03/2015 Meeting01
03/03/2015 03/03/2015 Meeting01
04/03/2015 04/03/2015 Meeting01
04/03/2015 10/03/2015 0
04/03/2015 05/03/2015 Meeting01
05/03/2015 06/03/2015 0
05/03/2015 06/03/2015 0
05/03/2015 05/03/2015 Meeting01

if end date are covered form 02.03.2015 to 05.03.2015 the value return is Meeting01. In-case Start date(05.03.2015) end date are covered next meeting from

Meeting02 to Meeting05 the value return is 0.Start Date(A) End date(B) date are covered next month the value return is "Data Not Available form the table".

if end end date are back date value return is "Check Entry".(Start Date 31.03.2015 but End Date is 28/03/2015).

please help me.file attached

[cbatrody]

Hi,

Try the following formula in C2:

=IFERROR(IF(INDEX(Condition!A$5:B$35,MATCH(A2,Condition!A$5:A$35,0),2)=INDEX(Condition!A$5:B$35,MATCH(B2,Condition!A$5:A$35,0),2),INDEX(Condition!A$5:B$35,MATCH(A2,Condition!A$5:A$35,0),2),0),"Data Not Avalabile form the Table")

See the attached file.

[Vandini.S]

cbatrody

thanks for the reply sir.value return is perfect.expect row no 38.


Start Date End Date cbatrody* formulas Required Format
31/03/2015 28/03/2015 Meeting05 less than Date

how do ignore back date entry.(Start Date 31/03/2015 End Date 28/03/2015)

please help me.file attached.

[cbatrody]

Modify the formula in C2 as following:

=IFERROR(IF(A2<=B2,IF(INDEX(Condition!A$5:B$35,MATCH(A2,Condition!A$5:A$35,0),2)=INDEX(Condition!A$5:B$35,MATCH(B2,Condition!A$5:A$35,0),2),INDEX(Condition!A$5:B$35,MATCH(A2,Condition!A$5:A$35,0),2),0),"less than sale date"),"Data Not Avalabile form the Table")

[Vandini.S]

its a amassing. thank you so much for your quickly response.

[Vandini.S]

return the value is perfect thanks you so much.

[cbatrody]

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.