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 ...
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.