Hello i have a spread sheet that i would like to assigned a value
minning that on b2 i have the product name on c2 i would type the
amount i need like 2 or 3 and on d2 its where i need to have a value
for each product like if i was to drop down the list and pick a item
off this lis then on d3 it would remember the value of the product and
on e2 would be the total amount of of this product cany ideas would be
greatly appreciated. thank you in advance


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