Hi guys.
Good day to you all.
I am trying to index/match the latest PO from a dataset consisted of a few dozen stores & thousands of SKUs. I have a PO detail sheet and am using helper column to match with my SKU qty on-hand summary data set.
Basically I lookup the store name & item number from the PO. But inside the list, there's multiple POs from the same sheet. So I wanted the summary to show the latest PO (ascending) either from the PO number itself or the date.
Any suggestions?
Screenshot 2023-07-26 140915.png
Screenshot 2023-07-26 140835.png
Bookmarks