Thank you Manas. All the best

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"manas" wrote in message
...
Thanks Ashish, it was really helpful, appreciate

"Ashish Mathur" wrote:

Hi,

You can use the SUMIF() function

=sumif(A1;A5,1,B1:B5)

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"manas" wrote in message
...
Is there anyway i can use Vlookup or any other lookup function, looking
for a
specific value in Column A and the function returns sum of all the
values
target Column?
E.g.
Column A has values 1 1 2 1 3
and column B has relative values 23 24 56 34 98

I need to look for '1' in column A and add up respective values in
Column
B.
Output for value 1 should be 81

Any help is appreciated

Thanks