Forum Discussion
Solved
Excel formula error - One cell equals to another on a diffrent page.
I am creating a workbook with multiple formula refrences to other sheets within the workbook (no external refrences) and for some reason the "cell range 1 = cell range 2 on another sheet" is showing...
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
Single cell worked. Perhaps it was the formating and the single cell compounding on eachother. Thanks for your help!
No problem. Just in case - if you in the cell the reference on the range in another sheet (have no idea why it could be needed) like
='Customer Data'!BI4:BQ4
when you have #VALUE if insert formula in other than from BI to BQ columns. In above columns it returns the value from the relative column in source sheet. You may check if use absolute references
='Customer Data'!$BI$4:$B$Q4
enter this formula in BH and copy to the right till BR. You'll have two #VALUE at the ends and copy of your BI:BQ in the middle.