Excel

[Iriwel]

Hello

Would be grateful for any assistance with the following problem I'm trying to resolve.

As shown below, I have an array of data from which I am trying to extract one item (namely Product g from Column B) which satisfies one criterion (Date1 - Column C) but not the second (Date2 - Column D) and then lists that item in Column A.

Am struggling to make this happen so any help and suggestions will be warmly welcomed.

Regards

James C

[#2]

@Iriwel If you are on a MS365 subscriber you may use FILTER as demonstrated in the picture below.

[#3]

@Riny_van_Eekelen 

Riny ... thank you so much for your reply. It worked a treat. Thank you again.

James C.