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

"linda4u" wrote:


Hello i really need help with aformula if possible, i have data on
sheet1 on b2 has the name of the product and on c2 the value of this
product,and on a1 i have the number for each of this products, can i
have a formula or something on sheet2 i need to type the product number
and b2 would have the product name on c2 tha amount i need for this
product but can this product remember the value that it was assigned on
sheet1 and only show the total after the amount needed its entered on c2
can d2 display the total amount of this product with out having the valu
of the product on the same sheet, PLEASE HELP MY BOSS ITS GOING TO KILL
ME IF I DON HAVE THIS DONE FOR HIM, AND I NEED MY JOB THANK YOU IN
ADVANCE


--
linda4u
------------------------------------------------------------------------
linda4u's Profile: http://www.excelforum.com/member.php...o&userid=35381
View this thread: http://www.excelforum.com/showthread...hreadid=551535