Hi

Use Vlookup
Assuming the 2 tables had 5 columns with the first being the team name
and the last being the points, then

=VLOOKUP(Team_Name,Sheet1!$A:$E,5,0)+VLOOKUP(Team_ Name,Sheet2!$A$E,5,0)

With your Team Names starting in A2 on sheet3 it would be
=VLOOKUP($A2,Sheet1!$A:$E,5,0)+VLOOKUP($A2,Sheet2! $A$E,5,0)
copied down the sheet.

Adjust ranges to suit.
The 5 in the formula is the column offset from the name where the number
of points are held. Adjust this also as you adjust the size of the
lookup table.

--
Regards

Roger Govier


"CJ" wrote in message
ps.com...
Is there any way to make excel follow the contents of a cell?

I have a league table where the totals change as points are gained and
need a third table to collate the points from table one which is an
archive whos values no longer chnage and table two which is the
current league table where teams (and the respective cells in which
the points values reside) move up and down according to results.

If you require further info please do not hesitate to ask.