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