JackSnakes
New Member
- Joined
- Aug 15, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi All,
I have been struggling with vlookup/hlookup to try to solve this.
I have a table, a representation of which is given below:
What I am trying to achieve is a way of finding out quickly how many bits I need of which product on a given day.
So, for instance, week commencing 14/8/23, how many pieces of DSM05 would I need?
Currently I'm checking each row, multiplying the quantity in a case by the number of cases required, then adding it all up at the end.
I think what I'm after is a formula where it looks at the date (day is unimportant) and, for that date, when product code is typed in, give a total number of pieces.
Is this possible at all?
Any help would be greatly appreciated, thank you
I have been struggling with vlookup/hlookup to try to solve this.
I have a table, a representation of which is given below:
| Index No. | Date | Day | Haulier | pallet Qty | Customer name | PO number | Product | Product code | Qty in case | No. of cases |
| 231386 | 14/08/23 | TUE | COLLECT | 0.04 | smiths | Super Firm 900g x 9 | DCSF09 | 9 | 2 | |
| 231387 | 14/08/23 | TUE | collect | 0.01 | jones | Super Firm 300g x 5 | DFSF05 | 5 | 4 | |
| 231388 | 14/08/23 | TUE | collect | 0.01 | jones | Smoked 300g x 5 | DFSM05 | 5 | 2 | |
| 231389 | 14/08/23 | TUE | collect | 0.00 | jones | Marinated 300g x 5 | DFMT05 | 5 | 1 | |
| 231390 | 14/08/23 | TUE | collect | 0.01 | Plumber | Smoked 300g x 5 | DFSM05 | 5 | 1 | |
| 231391 | 14/08/23 | TUE | collect | 0.01 | Plumber | Soft 250g x 12 | HOSO12 | 12 | 1 | |
| 231392 | 21/08/23 | TUE | COLLECT | 0.04 | smiths | Super Firm 900g x 9 | DCSF09 | 9 | 2 | |
| 231393 | 21/08/23 | TUE | collect | 0.01 | jones | Super Firm 300g x 5 | DFSF05 | 5 | 4 | |
| 231394 | 21/08/23 | TUE | collect | 0.01 | jones | Smoked 300g x 5 | DFSM05 | 5 | 2 | |
| 231395 | 21/08/23 | TUE | collect | 0.00 | jones | Marinated 300g x 5 | DFMT05 | 5 | 1 | |
| 231396 | 21/08/23 | TUE | collect | 0.01 | Plumber | Smoked 300g x 5 | DFSM05 | 5 | 1 | |
| 231397 | 21/08/23 | TUE | collect | 0.01 | Plumber | Soft 250g x 12 | HOSO12 | 12 | 1 |
What I am trying to achieve is a way of finding out quickly how many bits I need of which product on a given day.
So, for instance, week commencing 14/8/23, how many pieces of DSM05 would I need?
Currently I'm checking each row, multiplying the quantity in a case by the number of cases required, then adding it all up at the end.
I think what I'm after is a formula where it looks at the date (day is unimportant) and, for that date, when product code is typed in, give a total number of pieces.
Is this possible at all?
Any help would be greatly appreciated, thank you
