Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error
I have no problem with the index and match function as used in the video. However, I am running into a problem once I enter the formula because it automatically fills up rows beneath the cell where I entered the formula. If I then try to extend the formula down, it causes a spill error. Any ideas on how to tinkle with the options so as to stop Excel from automatically extending the formula down by itself?
Good to hear from you!
You'll need to open the 'options' menu and untick these rows: