FIFO from inventory

  • Thread starter Thread starter gknapp
  • Start date Start date
G

gknapp

I have developed an inventory for 5 products (raw matls). FIFO would b
easy if I created a separate sheet for each product. With the user i
mind, I wanted just 2 basic sheets: "Receiving Log" which maintains Qt
On-Hand and "Usage Log". As product is received an inventory code i
generated.

I would like the user to enter the product type in the "Usage Log" an
have the inventory code of the oldest product displayed to help wit
FIFO. In the "Receiving Log", I have identified the oldest inventor
code for each product but not in a predictable location - location i
dependent on the record with the oldest inventory code.

Attempts to access this code from the "Usage Log" end up with circula
reasoning. VLOOKUP doesn't work since the data is unsorted. MATC
looked promising but no luck. Aagh!!

Anyone have an idea? Thanks
 
Need more information about your layout and how you indicate the product age,
specifically the details about "the oldest inventory code for each product but
not in a predictable location - location is dependent on the record with the
oldest inventory code."

BTW, VLOOKUP has a 4th argument to require an exact match. Check it out in
Help. Ditto for MATCH.
 
Back
Top