I downloaded the file lookup-vba3. I think I can use this to help me populate a calendar.I substituted dates for Pen, Paper, and Eraser. I then had locations substituted for $ values. Where I have a date of say, 11/27/12, I have 10 locations delivering that day.
Using the template as shown in the screenshot under "Return multiple values horizontally or vertically (VBA)".
I cannot expand past column "C" to return multiple values. I think it is in the array code but I cannot figure out how to return values past column C.