VLOOKUP function not working :/

G'day All,

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;
VLOOKUP.xlsx

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.

Spicey

Awesome,

Do i need to do this as an array?

I get one row of data fill in with #N/A for some reason
INDEX NA.xlsx

Is this just an issue with the function not working on occasion?

double check cell D6 on 'Prod Summary' sheet... you've a space after day which is mucking up the index function

Ahh awesome,

Nice pick-up. Applied it to my actual master workbook, works a charm. Thanks for help!

Spicey