Forum Discussion
Search and fill
Hi guys, I need to help with one formula. I have two lists (INVENTORY and OUT) and I need in the OUT list C column will be automatically filled based on B column at the same list. And if I want to ...
if you wish to update the current inventory you will need a lookup and deduct it from inventory,
reattached the file
Thank you for your answer.
But if I deduct ART003 at inventory list is everything ok but I need to be subarticles deducted too based on ART003. It means if I deduct ART003 I need to be deducted all subarticles which has the same name.
For example ART001.1 is contained at item set ART001 and ART003 and in need to be deducted at all item set where this item number is contained.
Hope that is possible.
Thank you