I have a worksheet that contains the daily purchases for 4 products.

column B contains the products
column D contains the purchase price
column K contains the division
column J contains the day of the month

I need a formula that will pull the latest purchase price by product by
division. In other words the last purchase for the month and the associated
purchase price.

Thanks




--
col