Help finding Start date in sets of data

[calof1]

Hi,

I have sets of data which contains about 20 products. Some with different start dates. I have tried using SMALL formula in excel to find the date range with matches the product. This formula is in cell E2 on tab "Summary". However i keep getting an error message.

Does anyone have any ideas on what i need to change for this formula?

Many thanks,

[#2]

Remove the quotes that are around $E$4.

=SMALL(IF('Exceptions - Data Input'!$AB:$AB=$E$4,'Exceptions - Data Input'!$D:$D),1)

[#3]

@calof1 

I can't figure out your formula. I do know that I'd use MIN instead of SMALL to find the lowest date, given other criteria.

[#4]

hi@mathetes 

thanks for the below. I will try using min & remove the quotation marks from the comment above. Will see how this goes. 

Many thanks,

[#5]

hi@JMB17 

thanks for the below. I will update my spreadsheet.

Many thanks,