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...
Does this work?
=IF('Sheet1'!N2:N22="", "", 'Sheet1'!N2:N22)
If all cells in N2:N22 are either blank or text, you can use a shorter formula
='Sheet1'!N2:N22&""
That still gives the same result. It has something to do with the text being referenced because it works for some, but not for all.
