Lookup and sum row?
 

I need to lookup and sum a row, eg i want to lookup a value in column
A, and add the corresponding row between the say column B and J

so i want to do a vlookup, but instead of returning one value, i want
the sum.

cheers

Lookup and sum row?
 

Try this:

A20 = lookup_value

=SUM(INDEX(B1:J10,MATCH(A20,A1:A10,0),))

Biff

wrote in message
oups.com...
I need to lookup and sum a row, eg i want to lookup a value in column
A, and add the corresponding row between the say column B and J

so i want to do a vlookup, but instead of returning one value, i want
the sum.

cheers

Lookup and sum row?
 

Hi

as per my knowledge it is not possible in exl, bcs i m using this formula
daily,

but u can do in exess

Atul Jadhav
+91 9227110840

" wrote:

I need to lookup and sum a row, eg i want to lookup a value in column
A, and add the corresponding row between the say column B and J

so i want to do a vlookup, but instead of returning one value, i want
the sum.

cheers

Lookup and sum row?
 

On May 1, 2:53 pm, "T. Valko" wrote:
Try this:

A20 = lookup_value

=SUM(INDEX(B1:J10,MATCH(A20,A1:A10,0),))

Biff

wrote in message

oups.com...



I need to lookup and sum a row, eg i want to lookup a value in column
A, and add the corresponding row between the say column B and J

so i want to do a vlookup, but instead of returning one value, i want
the sum.

cheers- Hide quoted text -

- Show quoted text -

Thanks! worked perfect.

Lookup and sum row?
 

wrote in message
ps.com...
On May 1, 2:53 pm, "T. Valko" wrote:
Try this:

A20 = lookup_value

=SUM(INDEX(B1:J10,MATCH(A20,A1:A10,0),))

Biff

wrote in message

oups.com...



I need to lookup and sum a row, eg i want to lookup a value in column
A, and add the corresponding row between the say column B and J

so i want to do a vlookup, but instead of returning one value, i want
the sum.

cheers- Hide quoted text -

- Show quoted text -

Thanks! worked perfect.

You're welcome. Thanks for the feedback!

Biff