Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |