INDEX/MATCH #SPILL

[Dxmiian]

Hi,

I've used this formula many times in other sheets and I'm having an issue where I can't drag it down or click the box in the bottom right of the cell to include the formula in all other cells, i get #SPILL. Instead, the column has automatically filled in a light grey text. even though this works, the formula only works in other sheets when I bring rows across, if it includes the original cell of the formula, how can I have each cell contain the formula and not just a light greyed copped version?

Thanks

this is in cell B3

This is in cell B4 and onwards as you can see it's a lighter grey and not actually text. If I delete formula from B3 it deletes from the rest of the column also.

 

[Fluff]

If you are getting a spill error, then you are not using xl2007, so I suggest you update your profile.

Rather than matching A3:A12000 just use A3

 

[Dxmiian]

If you are getting a spill error, then you are not using xl2007, so I suggest you update your profile.

Rather than matching A3:A12000 just use A3

thank you, i changed the column Lookup to just columns and not certain cell range, this allowed me to extend the formula into more cells

=IFNA(INDEX(Options!L:L,MATCH('Carton Relabel Log'!A3,Options!K:K,0)),"")

 

[Fluff]

Glad to help & thanks for the feedback.

Also please do not forget to update your profile to show the version of Excel that you are using.