excel - Index(Match( on multiple criteria (Column D or Column E) -

i've been trying solve few days in excel. have access table connected in layout shown below:

this has thousands of rows of data filter/index(match( 2 different columns.

i need meet criteria of:

if sheet2!a1 = column d or column e 

any ideas if possible?

in worksheet want results, put formula column on unused row.

=iferror(index(sheet1!a$1:a$9999, small(index(row($1:$9999)+(((sheet1!$d$1:$d$9999<>sheet2!$a$1)+(sheet1!$e$1:$e$9999<>sheet2!$a$1))=2)*1e+99, , ), row(1:1))), "") 

fill right , down necessary catch available values sheet1 meet sheet1's column d or column e having value in sheet2!a1.

to use listobject table's structure cell references, have adjust row returned 1 compensate header row of table. first column (e.g. season) be,

=iferror(index(table_all_footballresults.accdb, small(index(row(table_all_footballresults.accdb[season])-1+(((table_all_footballresults.accdb[home]<>sheet2!$a$1)+(table_all_footballresults.accdb[away]<>sheet2!$a$1))=2)*1e+99, ,  ), row(1:1)), column(a:a)), "") 

fill both right , down.