Assume the following: Your Table 1 is in C6:E14. You second table is
in C20:D25. Enter the following formula in E20 and fill down to E25.

=SUMPRODUCT(--($C$6:$C$14=C20),--($D$6:$D$14=D20),$E$6:$E$14)

This will return the sum of the values in E6:E14 where the
corresponding value in C6:C14 is equal to the value in C20 and the
corresponding value in D6:D14 is equal to the value in D20.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)





On Mon, 8 Jun 2009 06:16:01 -0700, Lupus
wrote:

Hi

I have 1 table with data received from a customer. There I have Storenumber,
Articlenumber and units in stock. I wan't to match this data with a table
with a list of articlenumbers and how many units the need to reorder.

Table 1 looks like this
Custno Artno Units
101 201 3
101 202 2
101 203 9
102 201 1
102 202 2
102 204 5
103 205 3
103 201 5
103 202 3

Table 2 looks like this

Custno Artno Units
101 201
101 203
102 201
102 203
103 201
103 203


I want the result to look like this

Custno Artno Units
101 201 3
101 203 9
102 201 1
102 203 0
103 201 5
103 203 0

If there are no value of a spesific article I wan't 0 returned.

Is this possible?

Vlookup and match only generates errors

Eirik