I have created a two-worksheet Excel spreadsheet. The first worksheet, Master Schedule, is a complicated looking affair where I layout my schedule of posting blogs. The columns include among others:
Time for the posting to occur
Plus 17 columns for the various times of day I plan on scheduling posts
So one row might indicate that on Monday, at 9:30 AM, a Twitter post will be made for my first blog of that week. Across that row, in the column for 9:30 AM, a 1 will appear in that row.
The second worksheet is where I want to create a more visual, more easily understood grid for the schedule.
The first column shows 7 rows labeled for the days of the week. Across the top are columns labeled for the platform (LinkedIn, Twitter, Facebook) and the time for the posting.
In my approach, I only post to LinkedIn at 7:00, 8:00, 18:00 and 22:00. Likewise, I only post to Twitter at 7:30, 9:30, 15:30, 17:30 and 19:30.
I'm using a Vlookup formula. Below are a few examples.
For Monday at 7:00 am, =VLOOKUP($A3,'Master Schedule'!$C$4:$T$45,5,FAL
For Monday at 7:30 am, =VLOOKUP($A3,'Master Schedule'!$C$4:$T$45,6,FAL
The problem is that my Vlookup is only working in showing the first value it finds for a posting for that day. Thus, where Monday should reflect two postings, it only shows the first one at 9:30 AM. Thursday should also show two, but it only shows the first one at 18:00. Saturday should show four, but it only shows the first one at 8:45.
What approach do I need to use to pick up all the matches? Is the answer in the function or formula or is it in how I populate the "Master Schedule" sheet.
BTW, I use the "Master Schedule" to actually create the schedule. I want the "Visual Schedule" sheet to make it easy to see what the schedule looks like.