Index match headache

Hi,

I have 2 sheets, Sheet 1 is a daily summary of customer comments. I am trying to extract the data from Sheet 2 that has the comments for each customer in a weekly format so I need to match the date and the customer ID and return the comment for that date for each customer. I am usually ok with INDEX MATCH formulas but I have tried so many different versions now that my head is frazzled. I would be very grateful to anyone who can take a quick look at the example file and put me back on track,

Thanks very much,

Mark

Hi Fotis,

Thanks for the timely reply, I would have liked to have replied earlier... unfortunately my 'real' file still didn't work, although there was nothing wrong with your solution. Your solution was something I had already tried on my main file without any luck this morning but seeing that it worked on my example data set in your file I knew something was wrong in my main data set. I traced it in the end to a date picker control I was using, although it was happily linked to a cell and the date in the cell looked fine. That was the date lookup cell I was using for my index match to be able to quickly view the whole week's comments. The index match formula didn't work until I changed it to a data validation drop down instead... a shame because the date picker was a nice looking control.

I have learnt one thing to day from this, to take the formula out to a new workbook and play with it there, once I looked at your file I could see that I had tried that method and it hadn't worked before so there was something else not right in my main file, a few minutes of manually entering the source data and I found the date picker at fault. Thanks for the reply, I had got to the stage where I was 'quietly' cursing Excel and was getting looks from my colleagues at work

Rep added...thanks again for the quick reply.

Mark