Hi Chrissy,

A master list would certainly be a good idea. Do the two files contain the information from different advertisers? Or does the same advertiser exist in both workbooks?

If the former, then you could use a Vlookup formula in a third workbook, where you list the advertiser names and then pull the columns you want from the other workbook.

Something like

=if(isna(vlookup(A1,[filename1.xls]'Sheetname'!$C$4:$AJ$17,2,False)),if(isna(vlookup(A1,[filename2.xls]'Sheetname'!$C$4:$AJ$17,2,False)),"",vlookup(A1,[filename2.xls]'Sheetname'!$C$4:$AJ$17,2,False)),vlookup(A1,[filename1.xls]'Sheetname'!$C$4:$AJ$17,2,False))

So, if a vlookup in the first book returns no valid result, perform a vlookup on the second book, if no result found, return a blank, otherwise return the found value.

hth