VLOOKUP should work for everything except updating the stock level (that would require event code).
Here's a tutorial click here
Your TotalCost calculation on Sheet1 would be something like this for an item entered in A9
See if you can get that to work and post back. I'll then have a go at the stock level code.