post information below a merged cell table

[mikesaimname]

So I have a table with a huge amount of information and it is broken up into 31 sections, one for each day of the month.

On the left column are names of associates...

So row 2 has a series of merged cells with numbers... 1,2,3

Under that in row 3 are 6 categories which repeat 31 times under each series of numbers

Then under that is the data which is culled from a vlookup formula

What i need to do is have a formula that can find a name and a category under the number header...So I'd love to be able to say under number 3 in category C what's the value that matches Name XX

The issue with what I've tried is that the categories repeat 31 times so i can't do a simple hlookup