ExcelNooberino
New Member
- Joined
- Jan 2, 2019
- Messages
- 43
- Office Version
- 2016
- Platform
- Windows
Hi there folks!
So I've been trying to come up with a file that could help me to verify some data quickly that I've been doing and it's something like this: I need to validate if the batch of a specific product that was shipped respects the FEFO rule, I mean, first expired, first out. For that I need to extract some data from our system and cross info with the shipped products. The thing is, I need a formula that allows me to lookup the date of a specific product code and a specific batch because, a batch can be used in more than one code with different expiration dates. I don't know if I'm making myself really clear but basically I want it to return the correspondig expiration date of a specific product code & batch.
So I've been trying to come up with a file that could help me to verify some data quickly that I've been doing and it's something like this: I need to validate if the batch of a specific product that was shipped respects the FEFO rule, I mean, first expired, first out. For that I need to extract some data from our system and cross info with the shipped products. The thing is, I need a formula that allows me to lookup the date of a specific product code and a specific batch because, a batch can be used in more than one code with different expiration dates. I don't know if I'm making myself really clear but basically I want it to return the correspondig expiration date of a specific product code & batch.