Forum Discussion

Michael007's avatar
Michael007
Copper Contributor
Mar 02, 2020

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 insert number of PCS in D column OUT list I need to be automatically substracted at INVENTORY list C column.

I attached a file.

Please help me.

Thanks a lot

 

 

excel
Formulas and Functions
training

3 Replies

    • Michael007's avatar
      Michael007
      Copper Contributor
      Mar 08, 2020

      -Tyr- 

       

      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

  • mathetes's avatar
    mathetes
    Gold Contributor
    Mar 02, 2020

    Michael007 

     

    You need to do a bit more to explain what's supposed to happen here. Maybe quite a bit.

    AND, your current "Inventory" sheet contains some redundant (duplicate) entries in Column A...which would make for confusion over and above the confusion around all of the corresponding entries in Column B.

     

    On the "Out" sheet, I think the formula you want in Column C, specifically cell C2, is:

    =VLOOKUP(B2,INVENTORY!A2:B14,2,0)

    which can be copied down to other rows to retrieve the Article Name that corresponds to the Article Number in Column B.

    But the rest of the relationships and desired computations--which may be entirely clear in your mind--just don't come through, at least not to me.

Resources