Assuming your part numbers are in A1:A10 on Sheet2 and your quantities are
in B1:B10 and your part number on Sheet1 is in A1, then to get the
quantity in A2 on Sheet1 put:

=VLOOKUP(A1,Sheet2!A1:B10,2,FALSE)

Tyro

"Richard" wrote in message
...
I have a part number in columa A with the qty next to it in column B on
sheet 2. I want to send that qty to sheet 1 where that part number is.
Thanks
in advance