help with value in formula
 

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

help with value in formula
 

You need a database of your products with their prices, either in the same
sheet, in another sheet in the same workbook, or in another workbook. Say
this list is named Productlist. This list must be sorted. In A2 you then
enter the name of the product, in B2 the quantity, and in C2 the following
formula:
=IF(A2="","",VLOOKUP(A2,Productlist,2,FALSE)*B2)

"OSSIE" wrote:


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