look up more than one cell eg grid

Giganews Newsgroups
Subject: look up more than one cell eg grid
Posted by:  Jbcrtilla
Date: Sun, 28 May 2006

My column headings all show a students results (from 1 to 100) except for
column A which shows a students age, just written as a year and month, and by
cross referencing down and across I can see the grade, which I would then
like to input in a cell against the students name on worksheet 2:
        0  1  2  3  4  5  6  7  8 etc
5/ 1  E  E  E  E  E  D  D  D D
5/2    E  E  E  E  E  E  E  D
5/3    E  E  E  E  E  E  E  E
etc
If anyone can tell me how to do this, once I have set up the grid I would be
so grateful.

Replies