mikesaimname
New Member
- Joined
- Jul 29, 2020
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
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
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