Match
 

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

Match
 

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

Match
 

"Richard" wrote:
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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---