Re: Error returned (but not 100% of the time) when using IF with MATCH and INDEX
I've updated my formula to cover a wider time range and it works for most times. Certain times though return #NA for no reason I can see from a formula point of view. Is it another issue with how Excel deals with time?
I've attached the file for reference