Tough vba lookup

[lecet444]

Ok, so i have values (150 names) in a column A, in sheet 1 and correspondong qty in column B....

In sheet 2, i have 16 names in column A that are constantly changing, with their corresponding qty.

The values in sheet 2 column A are the same as sheet 1, quantities are different.

I want to add the quantities from sheet 2 to the previous quantity from sheet 1 with the correct names. And it would do that anytime sheet 2 is updated

 

[lecet444]

Bump

 

[sharpdog]

You may be able to try this:

=VLOOKUP(A1,Sheet1!$A$1:$B$150,2,FALSE)+Sheet2!B1

Paste this into cell C1 on sheet 2. Copy paste down through C16. It will sum the values to the right of the names that match.

Hope thats what you are looking for.

Luke

 

[lecet444]

Last bump im very time constrained here. Any help would be greatly appreciated

 

[lecet444]

The sheet witg the 16 are order forms, so theyre continuously updated with different names and quantitirs. Sheet 1 is the master and needs to be upto date via the addition of quantities in sheet 2.

 

[sharpdog]

So you want the values in Sheet 1 column B to be over-written with the addition of the current values plus the new values entered into column B sheet 2? If this is what you are looking for you need VBA code.

Luke