matching the column b(sku)c(count)with A

I need to match to the same row the B sku and the C qty to the same sku
in row A. not all sku in b will be in A. I need this so I can get the
counts in qty lined up on the same row as A for all the sku that exist
in A. ATOZ is A ... prod is B and the qty is C.
AtoZ # PRODUCT Qty
1002 1001 Total 14
1005 1002 Total 24
1006 1003 Total 4
10-1014-1 1005 Total 48
10-1014-2 1006 Total 33
10-1014-3 1010 Total 2
10-1014-4 10-1017-2 Total 1
10-1014-5 10-1017-3 Total 1
10-1017-1 10-1017-4 Total 1
10-1017-2 10-1056-3 Total 1
10-1017-3 10-1117-3 Total 4
10-1017-4 10-1117-5 Total 1
10-1017-5 10-1247-2 Total 2
10-1035-1 10-1247-3 Total 2
10-1035-2 10-1247-5 Total 1
10-1035-3 10-1248-2 Total 1
10-1035-4 10-1248-4 Total 1
10-1035-5 10-1248-5 Total 1
10-1051-1 10-1249-2 Total 1
10-1051-2 10-1249-4 Total 1
10-1051-3 10-1249-5 Total 1
10-1051-4 10-1250-2 Total 1
10-1051-5 10-1250-3 Total 6


--
sammc2
------------------------------------------------------------------------
sammc2's Profile: http://www.excelforum.com/member.php...o&userid=19402
View this thread: http://www.excelforum.com/showthread...hreadid=481995