VLOOKUP and IF nested formula?

Hi there,
Please see attached spreadsheet.

I am trying to use a VLOOKUP or HLOOKUP to achieve the following:

I am trying to find out the number of active hoods (pulled from the activehoods named range on the criteria tab) based on the facility in column B on the Raw Data! tab AND also based the time increment in column F on the Raw Data! tab.

I think i may be going about this all wrong, so any simpler suggestions are welcome!

I thank you in advance for your help!

Cameron

Sort of.
I'm ultimately trying to create a chart that tracks the ratio of hoods to RPh throughout the day. So, I initially need to get the number of hoods associated with a half hour increment. The active hood numbers differ based on what facility it is.
So I was hoping for just a formula in column E to account for this info (the number of hoods active during a particular time frame per facility is located under the activehoods named range on the criteria tab)

does that help clear up?

I apologize for the cross posting.

Thank you.