I need the value from what ever certificate, for example 35.
the value that i want to be returned is sum of column 3, 5 and 7 (table
array column numbers).
The quickest way would be to just insert another column with the sum of the
three colums but I'm affaid it will F@(#up my other spreadsheets which uses
the same summary sheet.

"Pete_UK" wrote:

Post some examples showing exactly what you want to do.

Pete

On Feb 10, 9:46 am, willem wrote:
In normal vlookup it returns only 1 value, is it possible to lookup a value
and than give the sum of certain columns?