Match formula does not work when made into a table

[lanc123]

Hi, this is my formula;

=IF(ISNA(MATCH(E$2,INDIRECT("'"&$A3&"'!$b$8:$b$11"),0)),0,MATCH(E$2,INDIRECT("'"&$A3&"'!$b$8:$b$11"),0)

i have rows of this formula which i want to put into a table (using excel for mac) but after highlighting and clicking a table template the results all change to zero.

any help much appreciated.
thanks