Oy...at first blush, I think this is beyond my Excel skills. The first part, comparing the Closing Stock to ROP can be done by...

=IF([Closing Stock]<VLOOKUP([Product],[Product Data Table],2)

But it's this next part that is stumping me:

• The maximum Date
• For the specified Product
• Where the Date is less than the Date on the specified line
• And Where New Order > 0

This would be easy peasy for me in Access, but in Excel it's beyond my meager skills. Maybe someone can figure out how to do this with the Reference functions or it might require a coded function. Or maybe I'm overcomplicating it. HELP!!!