Table Reference issues

[JamieP89]

Hi all,

Is anyone able to explain this table behavior?

When I try to reference another table I have made in the same sheet it is reference the cell I select as "(Table245[@RM])" - Instead I just want to select a specific cell so that I don't get the "#VALUE!" issue...

I've tried creating tables in another excel and they seem to behave how I would expect but not in this one?

Really weird...

Training Database2.xlsx
	A	B	C	D	E	F
4	Nov-21	66	1	0	10	77
5	Dec-21	#VALUE!	6	7	28	#VALUE!
6	Jan-22	#VALUE!	7	8	32	#VALUE!
7	Feb-22	#VALUE!	10	13	40	#VALUE!
8	Mar-22	#VALUE!	13	22	53	#VALUE!
9	Apr-22	#VALUE!	19	28	64	#VALUE!
10	May-22	#VALUE!	30	39	65	#VALUE!
11	Jun-22	#VALUE!	38	48	98	#VALUE!
12	Jul-22	#VALUE!	38	48	103	#VALUE!
Had full train but need PSRs

Cell Formulas
Range	Formula
B4:B12	B4	=SUM(Table245[@RM])
C4	C4	=SUM(Table245[@RN],Table2456[@RN])-Table24567[@RN]
D4	D4	=SUM(Table245[@NN],Table2456[@NN])-Table24567[@NN]
E4	E4	=SUM(Table245[@MSW],Table2456[@MSW])-Table24567[@MSW]
F4:F12	F4	=IF([@RM]="","",SUM(Table2456789[@[RM]:[MSW]]))
C5:C12	C5	=SUM(Table245[RN],'Completed Full Training'!$B$4:C5)-'Have had practical skills Rev'!$B$4:C5
D5:D12	D5	=SUM(Table245[NN],'Completed Full Training'!$B$4:D5)-'Have had practical skills Rev'!$B$4:D5
E5:E12	E5	=SUM(Table245[MSW],'Completed Full Training'!$B$4:E5)-'Have had practical skills Rev'!$B$4:E5

 

[jasonb75]

What range is Table245 located in?

If there is an offset between the table and the fiendishly formula then it could be a relative reference problem.

Without seeing that table as well, any reply that you receive will be little more than a guess as to what the cause might be.

 

[JamieP89]

@jasonb75 thanks for coming back to me! I've just this second figured out what the behavior was the table was using its "dynamic" autofill to predict what it thought I wanted. Turns out a simple CTRL Z sorts the issue