Formula results not updating when inserting cells

[mrstoked]

Basically, I have a formula that checks to see if the text of one column is within the text of another. Pretty simple.

However, when I insert cells then the formula does not automatically update even though I have it set to Auto Update.

Here's a short video of the problem: Screen Recording 2022-10-25 at 02.07.34.02 PM

This thing is frustrating me -- probably a little too much.

Thanks

 

[johnny51981]

When you are deleting a row/column that is directly addressed in a formula (such as cell F366, which had Santa Rosa County, FL), the formula that it was being used in now has nothing to point to on that side, so it will show you a #REF! instead. If this were a range, you would be able to sneak away no problem, but not this way.

I would suggest using a series of SUMIF or VLOOKUP, as opposed to matching and shifting them.

Also....the 2 counties that you deleted, check out the St. vs Saint