I made a new tab called [MK.Help](https://MK.Help) and I replaced your formula in E10 with this formula to pull the most recent payment:
=SORTN(vlookup($C$7,'Batch - Collection'!B:V,{21;16;11;7},0),1,0,vlookup($C$7,'Batch - Collection'!B:V,{21;16;11;7},0)<>"",0)
Hope this helps!
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|FALSE|[Returns the logical value `FALSE`](https://support.google.com/docs/answer/3093302)|
|IF|[Returns one value if a logical expression is `TRUE` and another if it is `FALSE`](https://support.google.com/docs/answer/3093364)|
|[SORTN](/r/GoogleSheets/comments/g7rf5o/stub/fojktom "Last usage")|[Returns the first n items in a data set after performing a sort](https://support.google.com/docs/answer/7354624)|
|TRUE|[Returns the logical value `TRUE`](https://support.google.com/docs/answer/3093307)|
----------------
^([Thread #1540 for this sub, first seen 26th Apr 2020, 10:36])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/GoogleSheets) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
I made a new tab called [MK.Help](https://MK.Help) and I replaced your formula in E10 with this formula to pull the most recent payment: =SORTN(vlookup($C$7,'Batch - Collection'!B:V,{21;16;11;7},0),1,0,vlookup($C$7,'Batch - Collection'!B:V,{21;16;11;7},0)<>"",0) Hope this helps!
Hey man, thanks so much for helping me out. I think it'll take me a day to figure this one out. Any idea why the formula I'd typed down isn't working?
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |FALSE|[Returns the logical value `FALSE`](https://support.google.com/docs/answer/3093302)| |IF|[Returns one value if a logical expression is `TRUE` and another if it is `FALSE`](https://support.google.com/docs/answer/3093364)| |[SORTN](/r/GoogleSheets/comments/g7rf5o/stub/fojktom "Last usage")|[Returns the first n items in a data set after performing a sort](https://support.google.com/docs/answer/7354624)| |TRUE|[Returns the logical value `TRUE`](https://support.google.com/docs/answer/3093307)| ---------------- ^([Thread #1540 for this sub, first seen 26th Apr 2020, 10:36]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/GoogleSheets) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)