Hi all so i am trying to do something that i don't know if is possible
I have created a table for training courses that can work like a calendar
The course details ar within the red boxes and can be anywhere within the range - but always come as a block.
on my team view sheet -
The formula needs to return the green boxes value in the first image into the correct green cells in the second image by first looking at the name in the purple box to determine which sheet, then match the course tiles from the red boxes on the second image with the blue boxes on the first one. the issue is the titles( blue boxes) on the first could be anywhere within the range L12:BL41
I have tried indirect to get the sheet name and then was going to use index and match with offset to return the value but nothing seems to work so i'm hoping someone much clever than me might be able to shed some light!!
I'm using windows and office 365
I have created a table for training courses that can work like a calendar
The course details ar within the red boxes and can be anywhere within the range - but always come as a block.
on my team view sheet -
The formula needs to return the green boxes value in the first image into the correct green cells in the second image by first looking at the name in the purple box to determine which sheet, then match the course tiles from the red boxes on the second image with the blue boxes on the first one. the issue is the titles( blue boxes) on the first could be anywhere within the range L12:BL41
I have tried indirect to get the sheet name and then was going to use index and match with offset to return the value but nothing seems to work so i'm hoping someone much clever than me might be able to shed some light!!
I'm using windows and office 365