Sum value with vlookup formula

[zahidrock]

I want to get sum value with vlookup formula, is it possible?

 

[Danerida]

If your "Name" column is column A on both sheets and your "Value" column is column B on both sheets, then:
In Cell B2 on the sheet you want the vlookup
=SUMIF('SHEET1_NAME'!A:A,A1,'SHEET1_NAME'!B:B)

Copy down as much as you need.
Dan

 

[vds1]

Try **,

=SUMIF(Sheet1!A1:A10,A2,Sheet1!B1:B10)

Sheet1 A1:A10 > Name
Sheet1 B1:B10 > Value

Change accordingly

 

[zahidrock]

if i use sumif function then it can take lot of time, i want to use vlookup function in this area. is there any function available which compare between vlookup and sum?

i have more then 1k name so that on there sumif function are too hard for me.

 

[XOR LX]

It is possible to do this with VLOOKUP, though it requires extra coercion, and it most certainly will be a lot less efficient than SUMIF for that purpose.

SUMIF was desgined to do just what you require. There is no better, nor faster function available.

Regards