vlookup and sum of colums
 

In normal vlookup it returns only 1 value, is it possible to lookup a value
and than give the sum of certain columns?

vlookup and sum of colums
 

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?

vlookup and sum of colums
 

The easiest way to return muliple matches is to use AutoFilter. You can also
use formula, but its a little more complex:

http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu200832


"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?

vlookup and sum of colums
 

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?

vlookup and sum of colums
 

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 -

vlookup and sum of colums
 

On Feb 10, 1:15*pm, 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?

If you want to sum relevant data form three columns, 3,5 and7, you can
use three vlookup function and then sum these three vlookups.
=vlookup(H1, A1:G10,3)+vlookup(H1, A1:G10,5)+vlookup(H1, A1:G10,7)