Excel links cells

[Const Gere]

I would like to know if and how to link couple of cells,
Let's say I have inserted a code in a cell, this code is
corresponding to coulpe of values in a tabele. I would
like that Excel would automatically insert the
corresponding values of this code (from the table) in
different cells on the same raw. Example: Say I punch a
code in cell A1 like GH23(which has a value in a table of
15 points and grade 5), then I would like that
automatically Excel would insert the value of this code 15
in the cell A2 and the vaule of its grade 5 in cell A3.
I would grealty appreciate any help.
Thanks.

 

[J.E. McGimpsey]

One way:

A2: =VLOOKUP(A1,table,2,FALSE)
A3: =VLOOKUP(A1,table,3, FALSE)

where "table" is the reference to your table.

 

[Don Guillett]

Perhaps a study of VLOOKUP from the HELP index.