Index Match function

[ExcelSur]

Hello guys,
I am getting error when using Index Match function. I have 2 tables with some data. I am trying to get the GL account number from second table based on 2 criteria, Please see attached excel file.

Thanks for your help

 

[bosco_yip]

Try,

In I4, formula copied down :

=IF([@Date]="","",INDEX(Table2[GL],MATCH(1,INDEX((Table2[Plant]=[@Plant])*(Table2[Material]=[@Material]),0),0)))

Regards

 

[ExcelSur]

Thanks for the solution Bosco. Really appreciate your help