Thread: VLookup

Hi

I am currently working on a project that works like a EPOS system for school in excel.

i have used a vlookup so that the user can enter the product code and the v lookup will then bring up the product information. u can change the qty of the item sold etc, and it adds up a total.

what i want to do that i am stuck with is once that item has been sold i then want to take the amount of that item sold of the stock qty of that item in my lookup table.

any help on how to do this will be great thanks. i just dont know where to start with it.

thanks

Tom

Hey

Thanks for your quick responce. Sorry i was so vaige.

Here is an example spreadsheet that covers what i am stuck on.

I have put in some comments to try and give as much detail as possible of what i am trying to achieve.

Thanks

Tom

Well, FWIW:

You can put a button on the form - a "ok - buy these" button. Then you can adjust each of the quantities on hand by the number purchased. Straight-forward, however...

I would probably do some type of log so that you'll have a record of each purchase. Without that type of thing, you can't get a handle on usage.

You should probably limit (or in some fashion, indicate) when the customer is ordering a quantity larger than the number on hand.

If you allow the down arrows to adjust through 0 to negative numbers, you could also handle returns in the same fashion.

Again, fwiw.

Bob

Hi

thanks for your help that seams what i would want it to do especialy with the log.

i dont have a huge understanding with excel. would you be able to give me any guidance for how i would achieve this?

thanks

Hey

Any help with using the lookup and taking away or adding stock to the related table? Still unsure how to do it!!! Is there a formula that I could use to do it?

Thanks

Tom