This happens all the time to me with my formulas. They basically stay null unless I force run them. I think that when multiple rows get inserted quickly, this seems to happen ...
I wonder if theres a way to delay and wait for the lookup to be finished before moving forward ahead with the other columns.