I have two spreadsheets with about 10 columns each. In the two files, 8 of
the columns are contain the same data, while the last two columns in each
file has unique data. The only difference in the two files are basically the
last to columns. File A has two unique columns and file B has two unique
columns. I need to create one file that compares 4 of the common columns in
each file, finding a match would copy all the common columns, plus the 2
unique columns from both files into the new file.
How can I accomplish this?

thanks in advance for any help offered...