NL(last) not returning the last record

I have searched on here and read the answers provided, but I don't seem able to make them work for me.

I'm trying to get the last vendor we purchased a specific item from. I have the list of items, but I can't seem to get the last record. I've entered the -/+ posting date every way I can think of.

This is what I've used so far.
=NL("LAST","ITEM LEDGER ENTRY","SOURCE NO.","Document Type","Purchase Receipt","Item No.",B3)

Any help would be greatly appreciated.



Please sign in to leave a comment.