Put an IF statement inside of a MATCH functin?

[LambChoptheKid]

Hi everyone,

I am attempting to create a function that searches an array for a date match, and if there is one, then subsequently check to see if a the time is between a designated "Start" time and "End" time within the row that contains a match. This function will be placed in the RUNNING? column.

This is the function that I've come up with so far, but I've hit a wall here: =IF(AND(MATCH(B2,M:M,0),

Is it possible to nest an IF function within a MATCH function to check if the allotted date is between the times?

If that is not possible, do you have any suggestions to help me solve this problem?

Thank you

 

[Legacy 143009]

Why don't you use countifs?
For example in C2:

=IF(COUNTIFS($F$3:$F$9,$A2,$G$3:$G$9,"<="&$B2,$H$3:$H$9,">="&$B2)>0,TRUE)

 

[LambChoptheKid]

Why don't you use countifs?
For example in C2:

=IF(COUNTIFS($F$3:$F$9,$A2,$G$3:$G$9,"<="&$B2,$H$3:$H$9,">="&$B2)>0,TRUE)

That worked!

I'm still pretty new to excel, so I've never worked with a countifs function before. Clearly I'll have to get familiar as it looks like it will be key to many of my projects.

Thank you!

 

[Legacy 143009]

Gald it did worked. Have a nice day!