Hi

I am trying to write a conditional IF and Vlookup Statement where if a customer stays in a hotel on 3 different occasions for vrying time periods in a month, but only eats in the hotel on one occasion, how can i write a if andf vlookup statement to pick up which occasion they ate in the hotel?

For example they stayed:

01/9/2013 - 6/9/2013
9/9/2013 - 11/9/2013
19/9/2013 - 26/9/2013

But they ate on the 22nd September and we can only identify the Customer by their Customer Reference Code which is unique to that customer.

Thank you