I am having issues using a VLOOKUP function to produce a summary table as you will see in the spreadsheet below. I have a gut feeling its the fact that my lookup value is not situated in the first column of my lookup table array, rather midway through it. I hope this is not the case as I am not able to change the position or arrangement of data in the 'Data' sheet. Or alternatively maybe I have made some dumb mistake that I cant find.
This is the spreadsheet;
Alternatively, I would have liked to create the same table using pivot tables, as this is more user friendly in allowing the date to be selected, however for the life of me I cannot work out how to get pivot tables to display text rather and numbers, I dont want a count of the XX comments etc, I want to display them like the above spreadsheet is meant to. So if any genius' have ideas on that, let me know.
Cheers in advance.