Forum Discussion

Jelena_Mihajlovic's avatar
Jelena_Mihajlovic
Copper Contributor
Feb 11, 2021
Solved

Excel #SPILL error with INDEX formula

Hello,  I have been using the INDEX formula for years. I use the formula to input data from one sheet into another matching on a common cell (eg, filling in department id's matching on employee id's)...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 11, 2021

Jelena_Mihajlovic 

That means you are on relatively modern Excel which supports dynamic arrays Dynamic array formulas and spilled array behavior - Office Support (microsoft.com) 

Most probably you may correct your formula by adding =@INDEX(... , but to re-write it in more correct way excluding rely on silent implicit intersection which is default behavior in legacy Excel

Implicit intersection operator: @ - Office Support (microsoft.com)

 

  • Jelena_Mihajlovic's avatar
    Jelena_Mihajlovic
    Copper Contributor
    Feb 11, 2021

    SergeiBaklan 

    THANK YOU!! I tried what you suggested and my formula now works.  I appreciate your help with this issue.  

    Thank you, Jelena 

Resources