Here is what I would like to do. when I type "a" in Column "TICK (a)" on table "InventoryTable" in sheet "Inventory List" It will copy its joining cell in Column "SKU" on table "InventoryTable" in sheet "Inventory List" to another table "InventoryPickList" in another sheet "Inventory Pick List" in cloum "SKU".
When I do this with VLOOKUP it only does the first value. I however want it to make a list of values, for instance there may be 20 items and VLOOKUP only notices the first one it see.
I am a novice at excel and want to do this with the help[ of formulas not code.
Your help on this would be greatly appreciate.
When I do this with VLOOKUP it only does the first value. I however want it to make a list of values, for instance there may be 20 items and VLOOKUP only notices the first one it see.
I am a novice at excel and want to do this with the help[ of formulas not code.
Your help on this would be greatly appreciate.
