Formulas fill differently when I hit 'save'

[gtd526]

Every time is hit "save" I get this result.
H:H and A:A are changing. There both correct when filled.

Wagers.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
90	#N/A	9/9		NFL	SPRD	$ 5.00	$ 4.35	TB	DAL	-7.5	-$5.00	AA:AN (SRS/Pass/Pts)
91											-$5.00
92			$119.81	Balance
NFL

Cell Formulas
Range	Formula
A90	A90	=INDEX('[NFL.xlsm]Weekly Picks'!$D$4:$D$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0))
H90	H90	=IFERROR(LOOKUP(2, 1/((COUNTIF($H$90:$H90,'[NFL.xlsm]Weekly Picks'!$H$4:$H$35)=0)*('[NFL.xlsm]Weekly Picks'!$H$4:$H$35<>"")),'[NFL.xlsm]Weekly Picks'!$H$4:$H$35),"")
I90	I90	=IF(1=MOD(MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0),2),INDEX('[NFL.xlsm]Weekly Picks'!$A$4:$A$35,MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)+1),INDEX('[NFL.xlsm]Weekly Picks'!$A$4:$A$35,MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)-1))
J90	J90	=INDEX('[NFL.xlsm]Weekly Picks'!$B$4:$B$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,FALSE))
L90	L90	=INDEX('[NFL.xlsm]Weekly Picks'!$G$4:$G$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,FALSE))
C92	C92	=124.81+K91

Wagers.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
90	W	9/9		NFL	SPRD	$ 5.00	$ 4.35		#N/A	#N/A	-$5.00	#N/A
91											-$5.00
92			$119.81	Balance
NFL

Cell Formulas
Range	Formula
A90	A90	=INDEX('[NFL.xlsm]Weekly Picks'!$D$4:$D$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0))
H90	H90	=IFERROR(LOOKUP(2, 1/((COUNTIF($H$90:$H90,'[NFL.xlsm]Weekly Picks'!$H$4:$H$35)=0)*('[NFL.xlsm]Weekly Picks'!$H$4:$H$35<>"")),'[NFL.xlsm]Weekly Picks'!$H$4:$H$35),"")
I90	I90	=IF(1=MOD(MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0),2),INDEX('[NFL.xlsm]Weekly Picks'!$A$4:$A$35,MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)+1),INDEX('[NFL.xlsm]Weekly Picks'!$A$4:$A$35,MATCH(H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,0)-1))
J90	J90	=INDEX('[NFL.xlsm]Weekly Picks'!$B$4:$B$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,FALSE))
L90	L90	=INDEX('[NFL.xlsm]Weekly Picks'!$G$4:$G$35,MATCH($H90,'[NFL.xlsm]Weekly Picks'!$A$4:$A$35,FALSE))
C92	C92	=124.81+K91

 

[Alex Blakenburg]

Is the workbook NFL open or closed ?
I don't believe COUNTIF can access a closed workbook in Column H and Column A is dependent on Column H

 

[jasonb75]

I don't believe COUNTIF can access a closed workbook

You are correct, none of the IFS type functions can access a closed workbook.