Hellol everyone. I have a trial balance and a list of journal entries: I am trying to retrive the values coming from the journal entries table to the trial balance by the voucher number. I using index and match with an array but i am getting #NAs . Dont know what i am doing wrong in the formula. Any help on retriving the values to the trial balance is greatly appreciated. I am using excel 2016. Regards. See link for the file
https://www.dropbox.com/s/bmygmec42klzwkn/Journal entries group.xlsx?dl=0
https://www.dropbox.com/s/bmygmec42klzwkn/Journal entries group.xlsx?dl=0
