I am making a sheet that allows a user to choose an item from a drop down. The columns are Item (drop down), Quantity, Cost (vlookup from another sheet), total cost (product(quantity,cost)).
My question is this;
is there a way that i can allow manual entry into the cost column that won't overwrite/rewrite the vlookup formula?.
Bookmarks