Excel 2007 : Return Value Based on Multiple Criteria

[pmhxcel]

Hi there,

I've heard such good feedback from co-workers about this Forum that I needed to join myself. I work with Excel a lot but dealing with with multiple criteria is something new for me.

I'd appreciate help to develop a formula or suitable solution to extract a single date for multiple categories where I need date per Category of Last Batch 2 (if there is Batch 2 in a Category) or date of First Batch 1 (if there is no Batch 2).

Have tried nested IF's and lookups but can't get required dates and I have a deadline for this.

I have attached test data with needed results if you could help. Much appreciate it and thanks