Can I do a lookup that will first search for Item, then date (nearest date) and return qty?
Item Date Qty
xyz 3-Jan 452
xyz 7-Jan 225
zzy 1-Jan 120
abc 6-Jan 352
abc 10-Jan 762
So if Item = xyz, and date = 4-Jan, then 452 should be displayed Qty.
if Item = xyz and date = 2-Mar, then 225 should be displayed are Qty.
Thanks in advance
Bookmarks