I have a list of items in Column A and have corresponding year and month values in Column B and C respectively. I am looking to find the minimum and maximum year in Column B (based on specific value in Column A), then find the corresponding month in Column C (only for max and min value) and then generate and fill in a Start and End date in Column E and F respectively. 
E.g. IF @Item = Laptop THEN FIND MIN,MAX of @YEAR and THEN FIND adjacent value in @Month. Finally formulate and display a date accordingly. 
Could i achieve this using a formula or is it out of scope and is better achieved using a macro?

[![enter image description here](https://i.stack.imgur.com/f2v8T.png)](https://i.stack.imgur.com/f2v8T.png)