Excel help

  dobie2 19:00 01 Mar 10


Looking for some help regarding a spreadsheet we are trying to put together for our nursery to track stock.
We currently have a spreadsheet with the stock we hold, nappies, bibs, the usual kids stuff.

Worksheet one has three columns, Item, Amount, Total Cost.
Worksheet two has three columns, Item, Stocklevel, Cost.

When I input the item on the first worksheet, i need it to look up the item on the second worksheet, update the stocklevel, multiply the cost and return that info back to the first worksheet under the total cost column.

Is it possible, me and the kids hope so.

Love Debs

  VoG II 19:23 01 Mar 10

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.

This thread is now locked and can not be replied to.

What is ransomware and how do I protect my PC from WannaCry?

Disney layout supervisor Rob Dressel on the challenges of visualising Moana

Siri vs Google Assistant