vLookup to Count Number of Completed Category Items for Report

[rstarr1]

Hi All,

I'm sure there is just something I'm missing. I'm trying to put together a simple report to show me how many completed items (Item Status) a user (User ID) has within a specific category (Category). The report will show both the current month's data and the data for the past year.

I've attached a sample workbook with 3 tabs... Report, Month, Year

In the end, I'd want the report to look like this...

Sample View.JPG


I hope this makes sense...
Thanks.