Two questions : named range display & alternate cell

[shahab47]

Hi Guys

I have a table assigned as a NAMED RANGE called "my_table". How do I display this in a cell, using certain formula? ie. I want a cell to display the text "my_table" if I write certain formula in it. see attached spreadsheet, task#2.

Another question.
How do I select alternate cell if they are named ODD/EVEN as explained in attached spreadsheet.

I have spent quite a few days trying to get to these but no luck.

Any help would be much appreciated. I have attached the spreadsheet with two tabs. task#1 and task#2.

Thanks
Shahab