Help Please!!!

  • Thread starter Thread starter linda4u
  • Start date Start date
L

linda4u

Hello i really need help with aformula if possible, i have data o
sheet1 on b2 has the name of the product and on c2 the value of thi
product,and on a1 i have the number for each of this products, can
have a formula or something on sheet2 i need to type the product numbe
and b2 would have the product name on c2 tha amount i need for thi
product but can this product remember the value that it was assigned o
sheet1 and only show the total after the amount needed its entered on c
can d2 display the total amount of this product with out having the val
of the product on the same sheet, PLEASE HELP MY BOSS ITS GOING TO KIL
ME IF I DON HAVE THIS DONE FOR HIM, AND I NEED MY JOB THANK YOU I
ADVANC
 
Your post is very confusing perhaps you can clarify a few things.

- C2 the value of the product, what do you mean by that? A dollar value?
- A1 the number of each product, is this a product number or is it an actual
number of how many of the product you have?

Please restate one line at a time (as above) what you want to see on sheet 2.
 
Assuming Sheet1 contains your product data in A1:C100 then

On Sheet2 column B:

=VLOOKUP(A1,Sheet1!$A$1:$C$100,2,FALSE)

On Sheet2 column D:

=C1*VLOOKUP(A1,Sheet1!$A$1:$C$100,3,FALSE)



This assumes data in Sheet2 is in row1 : if not, change A1 & C1 to An & Cn
where is row number.

Copy down as required.

To cater for error conditions or blank column (product number) use:

=IF(ISERROR(VLOOKUP(A1,Sheet1!$A$1:$C$3,2,FALSE)),"",VLOOKUP(A1,Sheet1!$A$1:$C$3,2,FALSE))


=IF(ISERROR(VLOOKUP(A1,Sheet1!$A$1:$C$3,3,FALSE)),"",C1*VLOOKUP(A1,Sheet1!$A$1:$C$3,3,FALSE))

HTH
 
Back
Top