Match

[Richard]

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

 

[Tyro]

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

 

[Max]

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

One way to extract it in Sheet1 via index/match,
with an error trap for unmatched cases

In Sheet1,
Assuming part numbers in A2 down
Put in say, B2:
=IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0)))
Copy down as far as required


---