Quote Originally Posted by brokenbiscuits View Post
Presumably this would be bringing back a #REF error in the cell, so if you do a ctrl+F search for #REF (making sure you're looking in values, not formulas in options) you should be able to find the cell(s) causing the problem?
I figured it out. The formula was pointing to a blank cell which is why I didn't get a #REF. Problem solved.