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)