Excel help

  dobie2 19:00 01 Mar 10
Locked

Guys

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

=VLOOKUP(A9,Sheet2!A1:C100,3,FALSE)*B9

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…