I'm not sure where "O5" comes into things, unless that's where you want to
put your VLOOKUP() formula.
Assuming your data in Report 1 starts at A2, you could put this formula into
any cell on row 2 of the sheet with Report 1 (and assuming that Report 2 is
on another sheet in the workbook)
=VLOOKUP(A2,Sheet2!A:C,3,FALSE)
now that will return an ugly looking #N/A! error when there is an Item # in
column A in Report 1 that isn't in Report 2, so to keep things neat and clean:
=IF(ISNA(VLOOKUP(A2,Sheet2!A:C,3,FALSE)),"",VLOOKU P(A2,Sheet2!A:C,3,FALSE))

and if Report 2 is in another workbook, then it takes on this format:
=IF(ISNA(VLOOKUP(A2,'[Book2]Sheet2'!A:C,3,FALSE)),"",VLOOKUP(A2,'[Book2]Sheet2'!A:C,3,FALSE))

Hope this helps some.


"Gameware" wrote:

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?