Excel VBA通过大型计算返回奇怪的结果

I've created a function in excel which basically searches a dynamic range in a For statement for a string and returns the value of the cell one column over. It's basically a budgeting function, but that's beside the point.I've created a function in excel which basicall