This is a hard one to explain, I am working on advanced lookups from one sheet to another based on a sheet someone else made and is using and doesn't want the format changed too much.
Basically it's a "calendar" by weeks and years of sales data on one tab, then on the second tab we want to pull specific totals from the first tab. Normally I use index match, vlookups, etc but the layout of the first tab doesn't seem to allow for this so I am seeking alternative ways.
First tab you will see a calendar for June `22 and the green boxes are the data that is being pulled into the second tab.
So on tab one I9 and I12 would be pulled and put into G3 and J3 on the second tab. I highlighted them in green. I could just put an =I9 and =I12 then manually do that for the whole year but that would take ages.
Is there another way to look this up? Keep in mind it is a running calendar for the whole year and beyond (Each section has a part with the month June '22 then July `22 and so on)
Sample attached, thanks in advance.
Bookmarks