Hi!

First of all let me thank you all for all your help.

So....
I have this spreadsheet containing twelve tables where six different persons
points are represented.
There are tables showing a ranked list over whos got the most points in
twelve different areas.
Is there a way to collect all points from all twelve tables into an overall
table?
All twelve tables are placed in a secluded area and can be marked in one
area.
The VLOOKUP do work if I add twelve of them together like this
VLOOKUP("IVAN";A1:E6;5;TRUE)+VLOOKUP("IVAN";A10:E16;5;TRUE)+ and so
on........, but......there must be an easier way?
Each persons points are always four columns to the left of their name, i.e.
the name on the first and his points at the fifth in a matrix.
The name on a row will vary as this is ranked lists.
Is there a function I can use.


--

Regards
Zadig Galbaras
A Perturbed Norwegian Agnostic
-----