Name range based on row and collumn header

Good Afternoon

I was just wondering If there is a simple way to name a range based on two criteria, I have attached the sheet as an example.

I want the range B2:B6 to be named based on Column header B1 and row range A2, I then want Range C2:C6 to be named based on Column header C1 and row range A2, so on and so forth

Name Range.xlsx

is this possible?

Thanks Dave

I hate to disappoint you... but there's no sheet attached.

Agreed. I did have a look at this yesterday, but nothing obvious immediately sprang to mind....

If you intend to use just a single dynamic named range at a time you could define it as

=OFFSET(INDEX($B$2:$C$11,MATCH(Month,$A$2:$A$11,0),MATCH(Test,$B$1:$C$1,0)),0,0,5,1))