How would I combine these two reports together using 05?

Report 1 (Sales report)

Item # Description 1 Qty Sold Publisher
12 360 BLAZING ANGELS 1 UBISOFT
25 360 CIVIL WAR 1 ACTIVISION
43 360 ELDER SCROLLS IV 1 TAKE 2
71 360 GHOST RECON AW 2 1 UBISOFT
78 360 HARDWARE ARCADE 1 MICROSOFT
91 360 LIVE 1 MONTH CARD 1 MICROSOFT
94 360 LIVE 3 MONTH CARD 1 MICROSOFT
97 360 LIVE POINTS 1600 3 MICROSOFT


Report 2 (Qty On-hand)

Item # Description 1 On-Hand Publisher
12 360 BLAZING ANGELS 6 UBISOFT
25 360 CIVIL WAR 2 ACTIVISION
43 360 ELDER SCROLLS IV 4 TAKE 2
71 360 GHOST RECON AW 2 3 UBISOFT


I just need to add the on-hand qty from report 2 to report 1.

Report one only generates items that have sold which is normally several
hundred items. Report 2 will generate the entire inventory database which is
more than 10,000 items.

Do I have to use item # to use VLOOKUP? If Column A was a UPC # or
Description instead of item # how would I use VLOOKUP?