V-Lookup, Match or Index when searching between two dates

Hi,

We have over 600 customer and I need a formula that tells me whether or not we have had a sale from a customer between two dates, so that I can monitor them on a weekly basis.

Example:
Customer A made sales on 01/06/2013, 02/06/2013, 05/06/2013 and 07/06/2013
Customer E made sales on 10/06/2013

Did Customer A make a sale during the week ending 09/06/2013 (From 01/06/2013 to 09/06/2013 inclusive) - The result should be Yes
Did Customer A make a sale during the week ending 16/06/2013 (From 10/06/2013 to 16/06/2013 inclusive) - The result should be No

Did Customer B make a sale during the week ending 09/06/2013 (From 01/06/2013 to 09/06/2013 inclusive) - The result should be No
Did Customer A make a sale during the week ending 16/06/2013 (From 10/06/2013 to 16/06/2013 inclusive) - The result should be Yes

I've tried a Vlook-up, but that doesn't allow me to search between two date ranges. Someone suggested SUMPRODUCT, MATCH and INDEX but neither of those worked Perhaps I am not doing the formula properly.

Would really appreciate it if someone could help me out. I have over 6000 transactions to analyse!!!

I have attached a Spreadsheet that should help to explain what i need.

Thanks in advance!!

That worked!!

Thank you!!