Good Afternoon all, I have just created what I thought was the perfect solution on a sheet of mine. I'm using the Vlookup formula to match dates to activities on a matrix I have been given. Using =IF(ISERROR(VLOOKUP(K2,FLAT60A,2,0)),"",VLOOKUP(K2,FLAT60A,2,0)) I can plot the date an event happened from the data in table FLAT60A, the problem occurs when I have 2 events that happen on the same date, the vlookup command only shows the first even. So, I would like to add another row below the first one and have a formula to say " if cell K9 has a value in it vlookup the next value on that same date.

I can put a sample sheet up if that's easier.

Cheers

Phill