Hi,
I have a query.
I have a 2 tables of data, similar to below and basically I need to analyse how many pallets move in and out in a month, the raw data is inputted on the the bottom table but I want to know if there is a way to do a vlookup or IF function to basically add in the total number of pallets on a specific day that have been brought in or sent out against a specific part code.
<tbody>
</tbody>
<tbody>
</tbody>
If you have any questions to help work it out let me know
thanks,
Steven
I have a query.
I have a 2 tables of data, similar to below and basically I need to analyse how many pallets move in and out in a month, the raw data is inputted on the the bottom table but I want to know if there is a way to do a vlookup or IF function to basically add in the total number of pallets on a specific day that have been brought in or sent out against a specific part code.
Part Code | |
Date | inbound |
01/06/2019 | **FORMULA NEEDED** |
02/06/2019 | **FORMULA NEEDED** |
<tbody>
</tbody>
Date | Inbound/Outbound | Part Code | Pallet quantity |
01/06/2019 | Inbound | ABC123 | 2 |
02/06/2019 | Inbound | ABC124 | 4 |
<tbody>
</tbody>
If you have any questions to help work it out let me know
thanks,
Steven