mitchella87
New member
- Joined
- Sep 24, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
I am using a simple cell reference formula to pull data from one worksheet (same file) to another. Rather than giving me the info from that cell, it is simply returning the reference I am typing.
On worksheet "Code Lookup" I'm typing =Unclosed!A1. I'm actually typing the = sign, and then navigating to the Unclosed tab and clicking on cell A1. It is returning =Unclosed!A1. The info in cell A1 is '00002020.
I've tried changing the cell formats in both places to text, general, numbers... I've used this exact same type of reference formula throughout the document with no problem.
Thanks,Andy
On worksheet "Code Lookup" I'm typing =Unclosed!A1. I'm actually typing the = sign, and then navigating to the Unclosed tab and clicking on cell A1. It is returning =Unclosed!A1. The info in cell A1 is '00002020.
I've tried changing the cell formats in both places to text, general, numbers... I've used this exact same type of reference formula throughout the document with no problem.
Thanks,Andy