I have a simple Excel sheet. Basically users choose an item from a
validated list. This then uses a vlookup to find the number in stock.
The user can specify how many they want and all I want to do is just to
decrease the number in stock by the number required. I thought it might
be something as simple as:
=vlookup($B$4,vl_stock,2)-$B$6 etc but this reduces all of the numbers
on the stock list for all items. I am sure there is a simple explanation
but I spent a day looking for a solution on the net yesterday and got
nowhere.
Would appreciate any insights you might have.


--

------------------------------------------------------------------------
's Profile: http://www.excelforum.com/member.php...o&userid=19962
View this thread: http://www.excelforum.com/showthread...hreadid=345877