Dear Excel community,

I need help for getting the same event start date and the same event end date for all the same events in my data list below. Take for instance for the event “TYR 2nd Southeast Asian Swimming Championships 2014”, I should be getting the start date as 15th June and the end date as 23rd June by referencing to the itemcode.

Only by having a consistent event start date and end date, I am then able to perform a vlookup using the key (“venue-startdate-enddate”) of another dataset.

Can anyone help please?



startdate_enddate.png