| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match 2 values
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match two values | Excel Worksheet Functions | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
| How do I match values in one spreadsheet to values in another? | Excel Worksheet Functions | |||
| How to match values in one column to values in another? | Excel Worksheet Functions | |||
Threaded Mode
