How many actually sales

ronjaham 

Couldn't see the picture clearly, too small...even with the enlargement (probably due to my graphics driver). A step-by-step description of your project would be more helpful in this case.

However...It sounds like you need to use a VLOOKUP formula to match the GTIN values from the two tables and return the quantity sold for each item. A VLOOKUP formula looks like this:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

where lookup_value is the GTIN value you want to match, table_array is the range of cells that contains the sales data, col_index_num is the column number that contains the quantity sold, and range_lookup is an optional argument that specifies whether you want an exact match (FALSE) or an approximate match (TRUE).

For example, if your order table is in columns A and B, and your sales table is in columns D and E, you can use this formula in cell C2 to get the quantity sold for the item in cell A2:

=VLOOKUP(A2,D:E,2,FALSE)

You can then copy this formula down to fill the rest of column C with the corresponding quantities sold for each item.

This way, you can compare what you ordered with what you actually sold.

I hope this helps.