The MATCH function will return the (relative) row in the table where a
match is found, so you could make use of that to add columns 3, 5 and
7 for that row, either in conjunction with INDEX or INDIRECT. If you
had posted some specific details of cell and column references I could
have proposed a possible formula for you.

Hope this helps.

Pete

On Feb 10, 10:15*am, willem wrote:
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?- Hide quoted text -

- Show quoted text -