Naming a cell

V

vikesh

I have a long list of data and want to name each cell individually b
using the reference of cell on the left and at the top. e.g.

Column A B C
Row
1 Maths Science
2 Jack 45 50
3 Andrew 88 40
4 Lalita 75 60
5 ---------------------------
6 ---------------------------
7 ---------------------------
& So on.
What I want is that cell B2 be named as Jack Maths or Maths Jack
cell C2 be named as Jack Science or Science Jack
cell B3 be named as Andrew Maths or Maths Andrew
cell C3 be named as Andrew Science or Science Andrew
& So on

If this thing can done using excel menu etc. then Please help.

Please note that I am using Excel 2000.

Thanks in advance

Vikesh Jai
 
N

Norman Harker

Hi Vikesh!

Select A1:C4
Insert > Name > Create [You'll see checks in Top Row and Left Column;
leave them]
OK

Test:
=Jack Science
Returns 50

However, you'll find that if you look at the defined names, you will
only see defined names for Jack, Andrew, Lalita, Maths, and Science.
What the formula example is doing is using the space as the an
intersect indicator; what is the value of the intersect of the Jack
and Science names.
 
Top