Hello Excel Brains -

I'm stuck with this worksheet, I've used it before and it's worked fine...but sometimes when I drag the array formula down it returns nothing. Can anyone give me a clue as to why it will not work?

On my last data set, one of the values was "NA"...once removed, the array formula worked liked planned...but this data set appears to be free of such values yet it still will not return values.

See columns FK -FN for the arrays.

Thanks for the help!


Array Problem.zip