Apr 20 2022 07:38 AM
I have an inventory tracking worksheet, it has multiple tables, the inventory received, the service requests and the remaining inventory. I have all the columns/formulas working, except one. I need to populate the price of the inventory item in inventory remaining, my only problem is that on inventory received there are entries for each piece of equipment, where as the remaining inventory sheet rolls the like items up into a single entry.
They need to also be matched up by item code and PO# as different PO's may have different prices for the same item. In the above instance in the remaining inventory sheet I need the price of the Latitude 7420 only once even though there are 7 latitude 7420's in the inventory in sheet. The price of an item is always the same in the same PO, it only changes between different PO's, so I will need to use the PO and item code as search criteria.
Apr 20 2022 01:54 PM