Try
D24Formula:
=IFERROR(INDEX('Master Invoice Entry'!A$2:A$31,MATCH(1,INDEX(('Master Invoice Entry'!B$2:B$31=B$17)*('Master Invoice Entry'!C$2:C$31=N$9)+(COUNTIFS($D$23:D23,'Master Invoice Entry'!$A$2:$A$31)),),0)),"")
Copy down!!
Try
D24Formula:
=IFERROR(INDEX('Master Invoice Entry'!A$2:A$31,MATCH(1,INDEX(('Master Invoice Entry'!B$2:B$31=B$17)*('Master Invoice Entry'!C$2:C$31=N$9)+(COUNTIFS($D$23:D23,'Master Invoice Entry'!$A$2:$A$31)),),0)),"")
Copy down!!
Last edited by shukla.ankur281190; 04-10-2018 at 01:26 AM. Reason: Changes as per Jet Message me
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks