Forum Discussion
#VALUE! error when referencing a range of cells
I'm getting a #VALUE! error in only certain cells when using the formula =IF(ISBLANK('Sheet1'!N2:N22), "", 'Sheet1'!N2:N22). A couple things to note, changing the formula to ='Sheet1'!N2:N22 gives th...
Everything in Sheet1 is coming in from an external data source.
Could the blank-looking cells contain one or more spaces?
