multiple criteria and within a range?

hhppyy · #1 07-17-2015, 05:53 AM

Dear All,

Please refer to the attachment.

For green cells, is it possible to use formula to determine if each of the Time cells (F2:AH2) is within the Section range specified (E3:E5) from the Section Table. Thanks All.

Regards.

NoSparks · #2 07-17-2015, 08:17 AM

I've always found the easiest way to work with times is to..... well, work with times.
If the times you have were real times rather than text, you could put this in F3 and drag across and down.

=IFERROR(IF(AND(F$2>=VLOOKUP($E3,$A$3:$C$7,2,FALSE ),F$2<=VLOOKUP($E3,$A$3:$C$7,3,FALSE)),"Yes","")," ")

see attached file.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to look up for multiple criteria	piper7971	Excel	5	06-16-2015 03:42 AM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Copy Multiple Rows to new workbook when multiple criteria is met.	flds	Excel Programming	5	09-30-2014 09:58 AM
Matching Criteria against a range when criteria is not in contiguous cells??	GMorris	Excel	9	08-20-2014 02:15 AM
Multiple criteria in SUMIF?	pumpkin head	Excel	1	02-17-2006 09:06 AM