Excel Reference to text returning "0" value on second column

Joined
Oct 18, 2017
Messages
1
Reaction score
0
Hello everyone. This is different than other cases I've seen here though related. Please bear with me. I have a workbook containing three sheets. I have four lines of text on the first sheet which I'm referencing in the second sheet by using for instance, ='Page 1'!A3:I3. It works well, except I've decided to add a new column to the left on the second sheet and so that pushes everything on the sheet to column B, and the new column is now A. When I do that, then the references return a value of '0'. If I remove the new column, then it fixes again. The formatting is the same (general) and calculations are on automatic. I'm confused as to what is causing that. Thank you for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top