Hi
I am using Vlookup function to find matching datat in another worksheet, i
want to add values if there is more than one matching values.
--
RZ

On Aug 22, 3:23 pm, RZ <R...@discussions.microsoft.com> wrote:
> Hi
> I am using Vlookup function to find matching datat in another worksheet, i
> want to add values if there is more than one matching values.
> --
> RZ

Can't. Try DSUM or SUMPRODUCT instead.

RZ wrote:
> Hi
> I am using Vlookup function to find matching datat in another worksheet, i
> want to add values if there is more than one matching values.
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=SUM(VLookups(lookup_value, lookup_range, return_column))

Alan Beban

let me give u example
I am trying to find corresponding values of below numerbs from another
worksheet :
Sheet 1
Col A Col B
1500
1600
1700
1800
1900
1200
1400
1300
1100
and sheet2 has multiple vlues as below
col A col B
1100 26
1100 45
1200 12
1200 23
1200 25
1200 31
1300 14
1300 23
1300 89
1400 24
1400 45
1400 45
1500 10
1500 15
1500 15
1500 45
1600 12
1600 12
1600 16
1600 87
1700 15
1700 18
1700 48
1700 56
1700 78
1800 10
1800 11
1800 45
1800 48
1800 59
1900 10
1900 15
1900 22
1900 48
1900 56

so i m trying to get the result in sheet 1

col A colB
1100 71
1200 91
1300 126 so on

plese urgenly.

thanks
--
RZ


"Spiky" wrote:

> On Aug 22, 3:23 pm, RZ <R...@discussions.microsoft.com> wrote:
> > Hi
> > I am using Vlookup function to find matching datat in another worksheet, i
> > want to add values if there is more than one matching values.
> > --
> > RZ
>
> Can't. Try DSUM or SUMPRODUCT instead.
>

thanks Alan but its not working, its giving me only the last matching number
from lookup_range not the sum of all the matching values, and if i try to
find exact match , its returning the first matching number! any other idea? I
will have more than 1000 rows with from where i need to find the sum of
matching values.
--
RZ


"Alan Beban" wrote:

> RZ wrote:
> > Hi
> > I am using Vlookup function to find matching datat in another worksheet, i
> > want to add values if there is more than one matching values.
> If the functions in the freely downloadable file at
> http://home.pacbell.net/beban are available to your workbook
>
> =SUM(VLookups(lookup_value, lookup_range, return_column))
>
> Alan Beban
>

Thanks smartin, SUMIF is working fine , i m sorry if my explanation made it
difficult to resolve the problem.
--
RZ


"smartin" wrote:

> RZ wrote:
> > Hi
> > I am using Vlookup function to find matching datat in another worksheet, i
> > want to add values if there is more than one matching values.
>
> Hi RZ,
>
> I think your description of the requirements threw everyone off the path...
>
> Try this in sheet1!B1
>
> =sumif(sheet2!A:A, sheet1!A1, sheet2!B:B)
>