Forum Discussion

Copper Contributor

Oct 13, 2022

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

MVP

Oct 13, 2022

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

Copper Contributor

Oct 13, 2022

I formatted the cells and then it filled as it should have. I appreciate your response!