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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…