L
Lupus
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
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