Forum Discussion
Excel formula error - One cell equals to another on a diffrent page.
Okay, at least that's not the formula as the text. Do you receive the #Value with reference on the single cell?, like
='Customer Data'!BI4
The issue here is not what are you doing? but what are you trying to do?
As far as I've used A1:A3=B1:B3 only will check your first cell and return true or false, so even if you use an array formula won't help as you'll end up checking as many items in the same range as if you'd go single cell with A1=B1.
So if you only want to check if it's the same then single cell will work out fine.
Carlos, that could make sense in some situations. An reference on the range not necessary returns the first value in the range. For example, if you'd like to make a reference on B1:B3 into D column you may use in D1
=B1
and drag down. Out of you range it returns zero.
Or you may put in D1
=$B$1:$B$3
and drag down. Result will be the same except out of your range you'll have #VALUE.
Is zero in your range or not you are not sure, but with #VALUE you may use some custom made error handling to put something what shall be outside the range.