help with value in formula

  • Thread starter Thread starter OSSIE
  • Start date Start date
O

OSSIE

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Please!!! 2
Spreadsheet help please 1
VBA / Macro Help Please 2
updating cell formula 4
Seperate formula depending on cell used 4
Vlookup and multiple data 5
Help Writing a SUM Formula 5
Insert columns and values programmatically with IF statement 9

Back
Top