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?

Hi Alejandro, Good to hear from you! You'll need to open the 'options' menu and untick these rows: Best, Ned

Hi Ned, Thank you, I tried your suggestion and it worked. I thought I had that ticked off from prior lessons. I wonder if a Windows update could've reverted it. Best, Alejandro

Follow this topic

Alejandro Hasselmeyer

Last answered:

10 Jun 2021

Posted on:

10 Jun 2021

Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error

in Introduction to Excel / Using Index & Match as a Substitute for Vlookup

2 answers ( 1 marked as helpful)

Ned Krastev

Instructor

Posted on:

10 Jun 2021

Helpful answer

Alejandro Hasselmeyer

Posted on:

10 Jun 2021

Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error

Submit an answer

related questions