Returning cel name in an intersection of named ranges

I'm looking to find the name of my named column range and the name of my named row range.
example:

rows 10 to 20 (ending in colum 20) is a range with the name 'Friday'
(each row has an 'indicator' in column A, like 'lesson 1')

every column, ending in row 20, has a unique name. that is also written in the column head

If I am in row 3, of column 5 (name = "bt"), I want to get the Name of the Row,
something like 'lesson 5'

Is that possible?
How does one do that?

1) Can you post an example workbook of what you are trying to do.

2) What do you want to do with the return value 'lesson 5'. In other words, what does the user do that causes excel to return the value 'lesson 5'. Do you just want a message box to appear?

Hi there,
@ 111StepsAhead

I'm trying to build a sort of 'daily changes' in a lessonplan.

A teacher report ill.

That means that a numer of lessons by him will not be given.
This calls for action, I need to find out which lessons on which day in which classes.
So far I managed to mark his lessons in a table where all lessons of each class are stated in a 'per day, per hour' column.
(Sheet Classes)
each column has the name of the class whose data (lessons) are in that colum.
The 'Ill teacher' is marked RED (interior of cells with his 'name' in the data
(example: en|Bt|B13 which means english; teacher = 'Bt'; room = B13) in column called "1c" (= class 1c")
This for exampe is the 7th lesson on Friday.
In another sheet, containing the info of each teacher, per day per hour, I want to 'look up' ALL teachers who do NOT have a class on that specific lesson (Friday lesson 7)

So I want to 'select' the Friday lesson 7 'row' foor all teachers and if the cell is empty I want to have the techer's 'name' (which is also the name of the named column)

In this way I can get lists (short ones) of available collegues, as sort of alternative.
With this I could build an separate sheet, containing all changes per class for that given day.

I'm trying to build something since they report ill before 08:00 and lessons start at 08:30, I want it to be done quick.

My next step, if this works weel, is to send a short message on Twitter, so pupils are notified 'in time' if their 1st lesson is NOT going to take place.

Until now, a collegue did this 'by hand' and on paper, I think it could be done easier and quicker in XL + VBA
If there are 'unsolved' 'gaps' shifting by hand is the last way to go for a few lessons.

Does this info help you?

Until now, a collegue did this 'by hand' and on paper, I think it could be done easier and quicker in XL + VBA
If there are 'unsolved' 'gaps' shifting by hand is the last way to go for a few lessons.

Does this info help you?

It can probably be done quicker in vba. My lunch break ends in 3 minutes. I'll take a further look later tonight if nobody else does.

Have a nice lunch, for a minute or so... LOL
Enjoy your weekend.
I live in the Netherlands, here it is 20:05.. on Fryday LOL

There is no real need for hurry, I'm curious if it might work.
Seems to me that this might make life a lot easier.
My director (headmaster) simply put this 'task' on my desk..

Thanks anyway

An example is to be found here
http://members.home.nl/bedlam/bedlamites/example.xls