• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index Match function

ExcelSur

Member
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
 

Attachments

  • Bayou.xlsx
    13.1 KB · Views: 4
Try,

In I4, formula copied down :

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

Regards
 

Attachments

  • Bayou.xlsx
    13.2 KB · Views: 1
Back
Top