Forum Discussion

Copper Contributor

Sep 22, 2017

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...

Formulas & Functions

Need Help

SergeiBaklan
Sep 22, 2017
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

SergeiBaklan

Diamond Contributor

Sep 22, 2017

Hi Kathy,

One of the possible reasons - if you add the formula into the cell which was formatted as text, the formula will be shown as text. If you change cell format after that that won't help itself, after that you shall enter into the cell edit mode and Enter again.

Kathy Jakel
Copper Contributor
Sep 22, 2017
Deleted everything from the cell, Set the format to General in both the starting and ending locations and renetered the formual. Still getting the #Value error.
- SergeiBaklan
  Diamond Contributor
  Sep 22, 2017
  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
  - Kathy Jakel
    Copper Contributor
    Sep 22, 2017
    Single cell worked. Perhaps it was the formating and the single cell compounding on eachother. Thanks for your help!