Referencing from another table returns "0"

[bmoore45]

Hey guys,

I'm trying to reference data from table a like so;

Table 1 formula entry
='Table 2'!J13

Table 2 formula entry in J13
=H:H-I:I

Tx guys,
Ben

 

[VoG]

What is this meant to do?

=H:H-I:I

 

[bmoore45]

What is this meant to do?

=H:H-I:I

Sorry, I don't actually know why it was that- it was meant to get the diff between two cells so it is now (example):

=a1-a2

Still the same prob though, returns the value "0"

 

[VoG]

Are you sure that you are referencing the correct cell?

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	10
2	7
3
4
5
6
7
8
9
10
11
12
13										3
Sheet9

Excel Workbook
	A
1	3
Sheet10

 

[bmoore45]

Yeah 100%,
Its working now though I just had to clear the formatting srry