Here is an example of what I am trying to produce
In the Item # column (A,2) I want to type an item number in and have the description, size and total $ loss (Columns B, C, F) data auto populate using data from sheet 2.
Here is what the data looks like from sheet 2
In the Item # column (A,2) I want to type an item number in and have the description, size and total $ loss (Columns B, C, F) data auto populate using data from sheet 2.
Item # | Description | Size | Missing Case | Missing Bottle | Total $ Loss |
Here is what the data looks like from sheet 2
Item # | Desc. | size | BTL Moving price | Btls/CS | Total $ |
65 | product 1 | 750.000 ML | 7.82 | 12 | 93.84 |
138 | product 2 | 750.000 ML | 4.83 | 12 | 57.96 |
139 | product 3 | 750.000 ML | 16.98 | 6 | 101.88 |
183 | product 4 | 750.000 ML | 9.27 | 12 | 111.24 |
283 | product 5 | 1.500 LT | 7.17 | 6 | 43.02 |
327 | product 6 | 750.000 ML | 31.85 | 12 | 382.2 |
328 | product 7 | 750.000 ML | 27.08 | 12 | 324.96 |
489 | product 8 | 1.500 LT | 7.15 | 6 | 42.9 |