Toppers Wrote:
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))

Hi iv tried this and did not work it says name or error all the data
its on sheet1 A1 has the number assigned for the thproduct it goes
from 1 to 100 b1 has the name of the product and C1 has a value of 1
or 6 or 10 so what i need on sheet2 its to type a number assigned to a
product on a1 an b1 shows the name of the product, c1 value d1 the
times i need this product and E if needed the total of this product, i
hope this helps Thank you for your help


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