Multi function look up/if/match

Hi Glenn,

Sorry for all the words. I have manually entered what I hope to see into the Fox Admin tab, if you scroll right to late 2015 you will see the NA, zeros, and ones. I have left the other formulas in.

In essence I need to match the day the photo was taken and the site code and return a value. I got that done in the formula in there. What I can't work out is how to add the condition about the time the camera was in the field (date deployed and date retrieved) so it will return an NA value if the camera wasn't out in the field at the time.

Thanks