using data from anohter worksheet

[thegeezer3]

Hello

ive got confused.

If i have two worksheets (w1 and w2) and on w1 i have a database o
products on ws1 i.e.
column A = product name
column B = cost per product
column C = weight

then in worksheet 2 i want to basically make an order form that wil
calculate the total cost of an order. I want to write the name of th
product and the number ordred and have the rest of the table b
autofilled with the total cost and total weight for that product.
dont want to copy and paste from one sheet to the other. Also i don
want to show unecessary data from ws1 on ws2 i.e. cost per product an
weight are not needed, just the name and the total cost and the tota
weight. this rules out my earlier idea of copying and pasting from on
ws to the other. There must be a more elegant way. Does anyone know o
one?


Any help appreciated

 

[Dave Peterson]

I would think you'd need a quantity, too.

But it sounds like you could use =vlookup() to return those values from the
second sheet.

If you've never used =vlookup(), visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
for nice instructions.