Forum Discussion
Trying to Pull Data From Another Sheet in Excel Using Cell References
Trying to Pull Data From Another Sheet in Excel Using Cell References but all I get is Jan-00
2 Replies
That probably means that the cell you refer to is empty.
Try a formula like this:
=IF('Other Sheet'!A1="", "", 'Other Sheet'!A1)
And if the source cell is not a date, set the number format of the cell with the formula to General (or whatever is appropriate).
Thanx HansVogelaar
I formatted the cells and then it filled as it should have. I appreciate your response!
B
