Removing #spill! and then #N/A from the range

Hi,

This SPILL is new to me as I've hardly encountered this situation until yesterday. Now it is doing my head in. I figured that by removing the obstruction in column below I had resolved the situation but I then end up with #N/A and greyed out formula below. I can't seem to find a resolution from Microsoft resources. I was using Index Match in the cell and it's the first time that I come across the border range affecting my formulas.

I tried adding @ to the formula which removed the problem but subsequently it doesn't return the correct answer!

Help is greatly appreciated.

The MATCH sysntax was the wrong way round.

=INDEX($B$1:$B$9,MATCH(E1,$A$1:$A$9,0))

You're welcome & thanks for the feedback.