Ask Your Question
0

How do I use the value a cell from a sheet in a formula on another sheet?

asked 2017-01-23 19:22:52 +0200

Mikie gravatar image

I have a value on the second sheet in cell C2 --> 02/01/2016 I have cells on other sheets with formula such as: --> =TEXT(Sheet2.C2,"mmm - YYYY")

Unfortunately the above equation (on the third sheet) yields the answer --> Dec - 1899

Everything I find concerns filling and propagating, but not using in an equation.

Would appreciate some help.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-01-23 19:48:59 +0200

Mikie gravatar image

Okay, I have it now.

I was using the word "Sheet2" as the reference, I used the name of the sheet and it worked.

D'Oh!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-01-23 19:22:52 +0200

Seen: 56 times

Last updated: Jan 23 '17