You can do that with this array* formula:


--
Best Regards,

Luke M
"Curtis" .(do not spam) wrote in message
...
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