True Value and referenced not working

I've been copying this formula down from cell to cell as I add vehicles to my list. However, the last two vehicles for some reason is showing "VALUE#!"

=IF(@INDIRECT("'"&A24&"'!$F$8")>0,IF(IFERROR(@INDIRECT("'"&A24&"'!$F$7")>@INDIRECT("'"&A24&"'!$F$8")-500,""),TRUE,""),"")

F8 on the tab that is referenced is showing "N/A", which is working not he previous tabs

=IF($C3>0,VLOOKUP(C3,'Master List'!$A$9:$H$63995,8,FALSE),"")

A24, 8th column has the milage entered as "40017"

Any ideas why it's not working now?