Need to compare multiple values including TIME between, and compare rate

I'm attaching a file that will do a much better job explaining what is stumping me...

Basically I have two sets of data. One will be new each week. I'd like to use the non-changing data as a base to compare new data to. The formula would need to match multiple values, including a 'time between', and then return whether a minimum rate has been met.

Thanks so much for any help!

Try this in cell F3 and copy down:

=IF(COUNTIFS(A$16:A$27,C3,D$16:D$27,"<="&D3,E$16:E$27,">="&D3,G$16:G$27,"<="&E3)>0,"Yes","No")

Does that do what you need?

Fantastic!! Would have never considered using COUNTIFS.... looks like it does the trick! Many thanks!

No probs. happy to help.

I'm sure there are prettier ways to deal with this, but glad my suggestion works for you.

Thanks for the rep point and please mark the thread as solved if you're happy with the solution.

BSB