Why do you need to reset them ? Doesn't Excel do that automatically ? one example: VLOOKUP. The 4th argument (TRUE or FALSE) forces an Exact match.
So, if you use a formula like
=VLOOKUP(A1,B2:C5,2,FALSE)
and then, intend to use another VLOOKUP formula like
=VLOOKUP(A3,B2:C5,2)
expecting that Excel would "assume" the False, well, you're in for a big surprise !
I will try to replicate your finding, but, I think this is very strange...
Like this thread? Share it with others